Streamlined database creation by leveraging Infrastructure as code principles via Terraform and Cloudformation. Utilized both native tools like pg_backup and cloud-based AWS backup services to ensure reliable data backups Implemented automation techniques to facilitate seamless quarterly minor version upgrades for RDS, Redis, and Kafka databases.Successfully managed the annual planning, testing, and implementation of major version database software upgrades using a blue/green methodology to ensure minimal downtime.Achieved cost savings by efficiently managing and freeing up resourcesDocumentation for repetitive database operations for DevOps and Devs to handle tasks like database migration, no-downtime index creation, column data type changes, etc.Created innovative tools and automated processes to streamline database accessibility for on-call engineers.Drove the implementation of monitoring and alerting systems utilizing efficient tools such as Datadog, AWS CloudWatch dashboards, and PagerDuty schedules.Applied various strategies and techniques to increase query speed and functionality

Responsible for maintaining approximately 300 databases which involved RDBMS (postgres) , In-Memory (Redis) and Search (Elasticsearch) databases via infrastructure as code (terraform)Working with data-eng organization for implementation of best practices for AWS Redshift MPP warehouseDatabase version upgrades including minor and major with near zero downtime using logical replication for postgres.Reduced AWS Database spend by around 300K per year by right sizing and optimizing the usage of the AWS infrastructure for databases

Responsible for data modeling of databases including RDBMS (Postgres, MySQL), NoSql (DynamoDB) and MPP (Redshift) .Guiding and sharing common database practices amongst developers and application architects . Assisting analytics and BI teams to design, maintain and optimize data warehouse queries on AWS Redshift. Prototyping and implementing high availability and load balancing solutions for postgres databases. Migrating database infratrusture from physical servers to AWS cloud.Managing databases in AWS Cloud and periodically optimizing infrastructure for cost savings. Managing Neo4j graph databases as a caching layer for the application logic.Investigated and implemented third-party reporting solutions with an overall strategy forintegration.

Worked on importing and exporting data from Postgres into HDFS, HIVE and Impala using Sqoop.Created Impala External tables and loaded the data in to tables and query data using Impala Query language.Involved in partitioning and joining Impala tables for Impala query optimization.Installed Oozie workflow engine to run multiple Hive jobs.Wrote shell scripts for rolling day-to-day processes and it is automated.Performed data modeling for RDBMS and NoSQL databases and established standards across modules.Created customized modules for automated application data processing.Developed big data loading processes using Hive and/or Impala.Developed JAVA API’s for providing data access to application layer.Recommended database performance improvements after checking database performance reports.Reviewed PL/SQL code and offered performance related improvements with the team as needed.Maintained production, test and development databases.Investigated and implemented third-party reporting solutions with an overall strategy for their integration.

Created data model using Toad Data Modeler based on business requirements.Developed required PL/SQL modules and created database logical and physical objects according to data model.Utilized PL/SQL for providing required data in report format to business analysts.Performed SQL tuning using standard techniques (i.e. execution plans, session trace, hints)Reviewed SQL code developed by the offshore team and provided recommendations.Worked with Senior DBA for infrastructure planning and future data growth.Collaborated with Infrastructure team (i.e. server administration, virtual infrastructure, storage etc.) for procurement of infrastructure based on requirements.Worked with application & infrastructure team for migration of infrastructure from one data center to another data center.Deployed applications on Performance, QA, Staging and Production Environment.Coordinated and performed application performance certification testing.Conducted meetings for daily status and task distribution among offshore team.Performed day-to-day database administration tasks and evaluated database performance reports on regular basis.Developed ETL jobs and customized reports using Shell Scripting + Oracle, SSIS, SSRS.