SUMMARY

• Over 10 years of success in administering and supporting complex databases
• Solution - driven IT professional with experience in AWS Cloud and Database Administration.
• Expertise in configuration, administration and performance tuning of PostgreSQL database in the Cloud (AWS & AZURE) as well as on-premise.
• Proficient in AWS cloud administration (IAM,EC2,RDS,S3,EFS,VPC,Cloudformation,AWSCLI,SNS,Cloudwatch). Reliably manage time in demanding deadline-driven settings.
• Proficient in Shell scripting and Database programming.

AREAS OF EXPERTISE

• Database Planning & Development
• Migration & Upgrades
• Performance optimization & Tuning
• Documentation, Maintenance & Support
• Programming
• AWS Administration
• Database Design and Analysis
• Team Collaboration & Coordination
• Backup & Recovery
• Disaster Recovery Strategies
• Test Development & Execution
• Troubleshooting & Problem Resolution

TECHNICAL SKILLS

Platforms: Windows server, Linux (Red Hat, Amazon Linux, Centos)

Databases: PostgreSQL, PostgresPlus Advance Server, MySQL, AWS RDS (PostgreSQL & Aurora), Oracle 10g/11g

Languages: PL/SQL, SQL, PL/pgSQL, Bash, Python

Tools: SQL Developer, Toad, PgAdmin 4, PostgreSQL Enterprise Manager (PEM), SQL Power Architect, PgPool-II, PgBadger, PgBouncer, Pgtune, GIT, Liquibase, Bitbucket, ERwin data Modeler, DbFit, Ora2pg, Pg configurator

Networking: TCP/IP, TNS, ODBC, JDBC, SSH, SCP

Cloud: AZURE, Amazon Web Services (AWS)

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

PostgreSQL Database Administrator

Responsibilities:

• Configured and administered PostgreSQL instances on AWS EC2 as well AWS RDS using industry best practices.
• Create and managed AWS RDS Aurora database for testing and possible replacement for PostgreSQL.
• Used Ansible playbooks to create new database for applications as requested.
• Worked with developers to implement schema changes and loading of data into databases
• Created database scripts as needed/requested.
• Configured and scheduled database backups using appropriate tools (snapshots/pg dump/wal-g,barman) and method for various environments.
• Managed databases ranging in size from 5gb to 500gb.
• Configured Auto-vacuum correctly to match environment and scheduled nightly supplemental runs of vacuum to clean up dead rows as well as update statistics.
• Used Dbfit to test database changes and build script.
• Ensured PostgreSQL instances are tuned using industry best practices. e.g Pgtune, Pgconfigurator.
• Performed query review and create indexes where necessary/appropriate.
• Migrated databases from other databases (oracle/SQL server) to AWS RDS PostgreSQL using AWS Data Migration Service (DMS) tool.
• Review database design and integration of systems and make recommendations regarding enhancements and/or improvements after migration to PostgreSQL.
• Used AWS Performance insight or pg stats statement to track down poorly performing database queries.
• Managed storage (EBS), subnet groups and security groups that are used to support database initiatives.
• Responsible for setting up and managing AWS Cloud watch metrics and alarms for database monitoring and alerting.
• Used pgbadger to analyze PostgreSQL logs.
• Configured SSL and Pam authentication as required by the project.
• Performed database patching as well version upgrade i.e. (9.6 to 10.0).
• Created and managed database objects such as users, roles, tables, indexes, views, sequences and permissions.
• Created or modify coded PL/PGSQL stored procedures, functions, and triggers.
• Created and approve pull request to complete database related tasks on Bitbucket.
• Assisted developers with setting up PostgreSQL database and installation of PgAdmin4 on local machines.

Confidential

PostgreSQL Database Administrator

Responsibilities:

• Created new database for new applications as requested in all or any environment and database objects as needed.
• Worked with application team to review and execute DDLs in Test and Production environments.
• Worked with Systems admin team & developer to build new servers for PostgreSQL install/configuration.
• Configured PostgreSQL Enterprise Manager (PEM) server and agents on new servers for monitoring all databases using the PEM console.
• Configured EnterpriseDB Failover Manager (EFM2.0) to manage a three node streaming replication setup. Also rebuild the master as a slave in PostgreSQL streaming replication setup.
• Used EDB Bart and pgdump to take database backups.
• Apply the latest PostgreSQL patches after review and testing in TEST environments. Performed PostgreSQL database upgrade from version 9.4 to 9.5.
• Configure and manage PostgreSQL (9.4) RDS database in AWS; Use AWS Snapshots to backup RDS databases to S3 for precautionary measures.
• Installed and configured PostgreSQL cluster on EC2 instances.
• Configure backup script (using bash) to backup databases and store them in AWS S3 buckets.
• Configure EC2 Security groups for Inbound/Outbound access to instances that PostgreSQL installed.
• Setup specific IAM profiles per group utilizing newly released APIs for controlling resources within AWS based on group or user.
• Create AMI from instance already configured with PostgreSQL (baked in ) to speed new instance creation.
• Created users and groups using IAM and assigned individual policies to each group.
• Monitor database growth and generate plans for growth forecast and capacity planning.
• Used Pgbagder to analyze PostgreSQL log and take appropriate action when necessary.
• Configured PostgreSQL 9.6 for testing new features and application compatibility in TEST.

Confidential, McLean, VA

PostgreSQL Database Administrator

Responsibilities:

• Performed flawless extraction, transformation, and loading of data from legacy systems into new databases.
• Contributed to decreasing need for downtime by developing and improving procedures for automated monitoring and proactive intervention.
• Created or modify coded PL/PGSQL stored procedures, functions, and triggers.
• Edited/configured Postgresql.conf and pg hba.conf file for performance, connectivity and security.
• Make architectural suggestions in order to improve performance and referential integrity.
• Used data modeling tools to reverse engineer database and generate logical database designs.
• Create database objects such as users, roles, tables, indexes, views and sequences.