We provide IT Staff Augmentation Services!

Pgsql/sql—dba/developer Resume

Spartanburg, SC

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

PGSQL/SQL—DBA/Developer

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

PGSQL/SQL—DBA/Developer

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

PGSQL/SQL—DBA/Developer

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

PGSQL/SQL—DBA/Developer

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.

Hire Now