SUMMARY:

• 7+ years senior DBA having knowledge and ability to perform all of the basic database management skills of data administration, web connectivity, physical structure, SQL and SQL applications, and overall architecture and database analysis.
• Lead the design, testing, implementation, maintenance, and control of the organization's physical, relational, and object - oriented databases across multiple platforms and computing environments.
• Configuring Postgresql Streaming Replication and Pgpool for load balancing. Managing the monitoring tools for better performance like PgBadger, Kibana, Graphana, and Nagios.
• Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.
• ETL and data warehouse design experience, especially with Greenplum.
• Proficient with all major PostgreSQL procedural languages (PL/PgSQL, PL/Perl, PL/PgPython, PL/Tcl) as well as some Oracle PL/SQL and SQL-Server T-SQL.
• Excellent SQL skills including query optimization, complex nested and co-related queries, common table expressions, window functions, and business analytical reporting.
• Extensive experience in developing Map-Reduce programs and aggregation frameworks using JavaScript's.
• Experience in Installation, Configuration and Troubleshooting of Oracle Database on Solaris OS, IBM-AIX, Red Hat Enterprise Linux (RHEL) and Windows on highly trans active and Very large databases.
• Extensively worked on Mmapv1&Wiredtiger storage engine. Experience in handling CRUD operations in MONGODB.
• Implemented various forms of replication in MySQL and SQL server environments based on company standards or client's needs.
• Implemented and utilized different backup tools such as mysqldump, Percona Xtrabackup and MySQL Enterprise backup based on company standards or client's needs.
• Expert level experience in Oracle RAC implementation & administration using Oracle Cluster-ware, Sun Cluster and VERITAS Cluster Server (Oracle Cluster ware setup and configuration, RAC installation, Configuration and Patching, RAC Backup and Recovery)
• Configured Automatic Storage Management (ASM) to fulfil storage needs. Experience in Implementing, configuring, trouble shooting, switchover, failover of Physical Standby Data Guard on 10g and 11g.
• Used ADDM (Automatic Database Diagnostic Monitor), AWR (Automatic Workload Repository), and ASH (Active Session History) for analyzing the database performance and tuning.
• Check the Accuracy of the Data being updated and ensure Perfect Reporting and Verify the Data Accuracy through various SQL Queries.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery planning and Security Management.
• Having Experience working on Data center servers and handling greater than 1.5 TB databases.
• Provided Greenplum and PostgreSQL trainings internally in Wipro Technologies and OpenSCG companies.
• Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.

WORK EXPERIENCE:

PostgreSQL DBA

Confidential, Jerseycity, NJ

Responsibilities:

• Plans and coordinates 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.
• Performs quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries.
• Reviews database design and integration of systems and makes recommendations regarding enhancements and/or improvements.
• Establish and maintain security and integrity controls. Experience in programming with PL/PGSQL.
• Expertise in trouble shooting the database performance issues along the with query optimization.
• Provides appropriate consulting, interfacing, and standards relating to database management, and monitors transaction activity and utilization.
• Prepares and/or reviews activity, progress, and performance reports.
• Plans and configures the physical database environment. Evaluates and recommends the purchase and utilization of technologies such as DMBS/s, servers, extract and conditioning tools, metadata management, security tools and archival and recovery tools and data access.
• Develops project plans for implementing database environments. Provides input to technical projects and oversees the tactical aspects of all database related tasks.
• Diagnoses, resolves and implements preventive measures to prevent problems for availability, recoverability and performance of all supported database environments.
• Recommends and oversees implementation of database level configuration changes to optimize performance. Ensures 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)
• Tuning 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.
• Studied and stayed current on features and functionality of PostgreSQL.
• Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster recovery.
• Scheduling daily Point in time recovery (PITR) to the development environment for proper product testing.
• Configuring log analyzation tools like pgfouine and pgbadger etc.
• Installing and configuring check postgresql.pl plugins for Monitoring PostgreSQL instances effectively.
• Proactive in updating the latest security patches to database, which are provided by PostgreSQL open source community.

Environment: PostgreSQL, PL/PGSQL, Java, Python, Shell Script, Windows, SUN Solaris, Linux, AIX.

PostgreSQL DBA

Confidential, Weehawken, NJ

Responsibilities:

• Ability to proactively identify, troubleshoot and resolve live database systems issues. Knowledge in database design including logical and physical design.
• Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore
• Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases. Monitoring databases to optimize database performance and diagnosing any issues.
• Daily log analysis using pgbadger tool and query tuning.
• Maintaining custom vacuum strategies at table and db level.
• Identifying and fixing the issues on gpcrondump and gpdbrestore. Fixing the issues on External tables, gpfdist and gpload utilities.
• Fixing heap and Append-only table corruption issues.
• Recovering the failed segment instances using gprecoverseg incremental and full recovery. Configuring and fixing the Issues with Pgadmin-III client application.
• Monitoring the DB growth for every month in DWH databases and planning to implement the table partitioning for better performance.
• Develop, implement, maintain policies and procedures and document database architecture to ensure the security and integrity of the databases.
• Responsible for monitoring environments using monitoring tool viz. Nagios, Check Postgres.pl, pgOn, custom scripts and other supporting tools like pgBadger and tailnmail.
• Hands-on experience on database administration, backup recovery and troubleshooting in co-location environments.
• Ability to thrive in a fast-paced, deadline-sensitive environment.
• 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.
• Experience supporting a mission-critical database environment with 24x7 On-Call Support including weekends.
• Identifying and resolving incidents and address to user problems/concerns. Attending initial sales calls to Offer technical solutions for customer queries in pre-sales cycle
• Performing minor and major level upgrades using minimal down by prior testing in test boxes with accurate time notifications.

Environment: PostgreSQl 8/9 and Command center, Linux, PL/PGSQL, IDOL tool.

DBA

Confidential, Santa Clara, CA

Responsibilities:

• Responsible for issue resolutions participates in client meetings and presentation. Managed performance of team members, career, training and development planning.
• Facilitated goal and objective setting, promotions and performance reviews. Experience designing database structures, indexes, views, partitioning.
• Implementing backup and recovery (Logical and Online) Setup and maintenance of postgres master-slave clusters utilizing streaming replication.
• Removing the Index bloat concurrently to improve the performance. Scheduled maintenance activities to vacuum, analyze to improve the query response time.
• Maintaining custom vacuum strategies at table and db level. Query optimization and troubleshooting.
• Hosting Weekly calls for customers as per the schedule.
• Close collaboration with engineering on schema additions and updates utilizing Liquibase. Participation in week-long on-call rotations
• Configuring log analyzation tools like pgfouine and pgbadger etc.
• Controlling migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
• Data migration while upgrading database versions ranging from 8.2 to 9.5. Troubleshoots with problems regarding the databases, applications and development tools.
• Performed Architectural Health Check (AHC) on client systems with recommendations.
• Active participant in discussions related to Backup Strategy, DC/DR architecture
• Cross-datacenter disaster recovery and backup architecture. Performing schema management, database sizing, maintaining privileges. Data migration while upgrading database versions.
• Providing response for all system / database issues on 24 x 7 Schedule responding to critical events and situations outside normal work hours.

Environment: PostgreSQl 8.x/9.x, PostgreSQL plus Advanced Server, centos, RHEL.

DBA

Confidential

Responsibilities:

• Implemented database monitoring system using Oracle Enterprise Manager Grid Control. Installed and configured RMAN for automatic backup and recovery of databases at pre-defined schedules
• Designed, developed and maintained PostgreSQL database architecture
• Single Point of Contact for technical support, application support, users and help desk personnel of all applications.
• Expertise in writing Shell Scripts. Setting up new environments (Development, Production etc)
• Schema, Table, Database refreshes on demand for dev teams. Cloning the databases from Production to Test environment using Hot/cold/export/RMAN backups.
• User creation and providing necessary Roles, Privileges and quota as per the requirement. Monitoring the Table spaces and adding/resizing data files.
• Performing reviews on the design and code frequently to ensure the site standards are being adhered to.
• Evaluating releases of Oracle and its tools, and third party products to ensure that the site is running the products that are most appropriate.
• Installing new versions of the Oracle RDBMS and its tools that access the Oracle database.
• Planning and implementing backup and recovery of the Oracle database.

Environment: PostgreSQL 8.3/8.4, Core Java, C++, Centos, RHEL 5, AIX 5