SUMMARY:

• 5+ years of experience as a DBA, with strong knowledge in database management, and ability to perform data administration, web connectivity, physical structure, SQL and SQL applications, and overall architecture and database analysis.
• Experienced as a DBA and technical support Engineer. 5+ Years of experience in PostgreSQL RDBMS with knowledge of installations and Configurations, Backups, Warm/Hot Standby/Streaming Replication/pgHA, pgbouncer,PgBadger,pgTuples, pgRepack, and ora2pg.
• Expertise and Interest includes in Administration, Database Design, Performance Analysis, and Production Support for Large VLDB and Complex Databases.
• Expert knowledge in monitoring tools like Naigos, LibrNMS and PEM (postgres enterprise manager)

PROFESSIONAL SKILLS:

RDBMS: PostgreSQL 10, 9.6, 9.5.5,9.4,9.3,9.2 etc, Oracle 10g

Languages: Shell scripting, PL/PGSQL

Operating Systems: Linux, Unix, Windows

Replications: Binary and Object level replications

Backups: Logical and Physical backups

High Availability: WarmStandby, Hotstandby, Streaming replication, Cascade replication etc.

Cloud Environment: AWS: EC2 and VPCX console, RDB instances

PROFESSIONAL EXPERIENCE:

Confidential, Spartanburg, SC

Responsibilities:

• Plan and coordinate the administration of PostgreSQL databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation, long - range requirements, and operational guidelines.
• Perform quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries.
• Experienced in working with pg Barman to centralize all backups
• Good in creating Binary level and Text indices for document research
• Expertise in Jenkins to schedule automated jobs on Development/Production
• Extensively worked on creating foreign data wrappers to connect to other data resources from within postgres.
• Review database design and integration of systems, and makes recommendations regarding enhancements and/or improvements.
• Extensive knowledge in Architecture/Design of Extract, Transform, Load(ETL) environment using Pentaho.
• Install and configure in monitoring tools like Naigo’s, PEM and LibraNMS.
• Involved in ETL’s Team to Identify and Resolve ETL Development and production issues
• Knowledge in Setup and maintenance of Postgres master-slave clusters utilizing streaming replication
• Experience in security access control, testing, configuration management, version control, highly available web applications.
• Actively Involved in working with Postgres Modules like pg stat tuples/indexes,Pg badger and pg repack etc.
• Experience in working with JIRA on ticketing system’s and to Manage Workflow of team.
• Tune auto vacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
• Experience in programming with PL/PGSQL. Strong experience with load balancing using pg pool
• Expertise in trouble shooting the database performance issues along the with query optimization.
• Perform maintenance on the server without minimal downtime by using pg repack
• Provide appropriate consulting, interfacing, and standards relating to database management, and monitors transaction activity and utilization. Prepare and/or review activity, progress, and performance reports.
• Diagnose, resolve and implement preventive measures to prevent problems for availability, recoverability and performance of all supported database environments.
• Recommend and oversee implementation of database level configuration changes to optimize performance.
• Ensure maintenance of physical integrity of all production databases.
• Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.
• Develop SQL reports that meet client expectations for the application (used by custom application).
• Tune auto vacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
• Contributed to decreasing need for downtime by developing and improving procedures for automated monitoring and proactive intervention.
• Configure log analyzing tools like pgfouine and pgbadger etc.
• Install and configure Nagios check postgresql.pl plugins for Monitoring PostgreSQL instances effectively.

Confidential, Raitran, NJ

Responsibilities:

• Experience in administering large, multi-terabyte PostgreSQL databases.
• Strong experience in performance tuning & index maintenance in RDS VPCX and EC2 console.
• Ability to proactively identify, troubleshoot and resolve live database systems issues.
• Providing response for all system / database issues on 24 x 7 schedule responding to critical events and situations outside normal work hours.
• DBA with experience in PostgreSQL. Ability to understand/modify command titles and server processes can be identified for potential related platforms AWS
• Experience with DB clusters stored in a common file system location, Mapping using symbolic links from designated Tablespaces
• Responsibilities for reviewing external codebase and implementing and testing on VPCx environment
• Experience setting up Write -Ahead Logging (WAL) in AWS Environment.
• Experience designing database structures, indexes, views
• Daily log analysis using pgbadger tool and query tuning in cloud environment.
• Maintaining custom vacuum strategies at table and db level.
• Develop project plans for implementing database environments. Provides input to technical projects and oversees the tactical aspects of all database related tasks.
• Administration of PostgreSQL databases, production lifecycles in a AWS environment
• Create users, establish database security, create resource queue, performance tuning in terms of query execution etc in AWS environment.
• Removing the Index Bloat Concurrently to improve the performance.
• Proactively update the latest security patches to database, which are provided by PostgreSQL open source community

Confidential, Philadelphia, PA

Responsibilities:

• Plan and coordinate the administration of PostgreSQL databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation, long-range requirements, and operational guidelines.
• Perform quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries.
• Review database design and integration of systems, and makes recommendations regarding enhancements and/or improvements.
• Experience in programming with PL/PGSQL
• Strong experience with load balancing using pg pool
• Expertise in trouble shooting the database performance issues along the with query optimization.
• Provide appropriate consulting, interfacing, and standards relating to database management, and monitors transaction activity and utilization.
• Prepare and/or review activity, progress, and performance reports.
• Diagnose, resolve and implement preventive measures to prevent problems for availability, recoverability and performance of all supported database environments.
• Recommend and oversee implementation of database level configuration changes to optimize performance.
• Ensure maintenance of physical integrity of all production databases.
• Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.
• Develop SQL reports that meet client expectations for the application (used by custom application).
• Working knowledge of IDOL tool.
• Tune auto vacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
• Contributed to decreasing need for downtime by developing and improving procedures for automated monitoring and proactive intervention.
• Configure log analyzing tools like pgfouine and pgbadger etc.
• Install and configure Nagios check postgresql.pl plugins for Monitoring PostgreSQL instances effectively.

Jr. Assistant Admin

Confidential, Mi

Responsibilities:

• Creating and maintains all databases required for development, testing, and production usage.
• Performs the capacity planning required to create and maintain the databases.
• Working closely with system administration staff because computers often have applications or tools on them in addition to the Oracle Databases.
• Monitoring databases to optimize database performance and diagnosing any issues.
• Develop, implement, maintain policies and procedures and document database architecture to ensure the security and integrity of the databases.
• Implement data models, database designs, data access, table maintenance and code changes together with our development team.
• Experience in code migration, database change management through various stages of development life cycle.
• Work with development and operations teams to tune production queries for optimal performance.
• Implement and monitor replication for high availability and disaster recovery scenarios.
• Review new database schema changes.
• Monitor and manage database indexes for optimal performance. Automate the configuration management of database and Big Data systems.
• Performing schema management, database sizing, maintaining privileges.
• Installing and monitoring PostgreSQL database using the standard monitoring tools like Nagios etc.
• Daily log analysis using pgbadger tool and query tuning. Maintaining custom vacuum strategies at table and db level.
• Monitoring the DB growth for every month in DWH databases and planning to implement the table partitioning for better performance.
• Monitoring the bloat repot on every table and performing maintenance with minimal downtime.
• Performing minor and major level upgrades using minimal down by prior testing in test boxes with accurate time notifications.

Confidential

Responsibilities:

• Strengthened database knowledge by being part of a real time ETL project.
• Researched Teradata SQL. Enhanced report writing and presentation skills.
• Trained on assignment(s) which helps to achieve my specific objectives for work-based learning related to my STEM degree. Learned my goals regarding specific knowledge, skills, and techniques during my with Confidential .
• Confidential given complete Project based Application development assignments to help me in achieving specific work-based learning objectives which include construction and managing an organization’s computer systems and supplying technical support, get proficiency in various programming languages.
• Confidential trained me on different analytical tools and helped me to complete on the learned technologies.
• Involved in Assist engineering team in the design of appropriate DB Schema and indexing strategy for performance and scalability
• Involved with DBA team to perform daily activities, Installation, configuration, Backups, Maintenance tasks, Monitoring servers and other activities to improve the performance.