SUMMARY:

• 7+ years senior DBA having knowledge and ability to perform all of teh basic database management skills of data administration, web connectivity, physical structure, SQL and SQL applications, and overall architecture and database analysis.
• Lead teh design, testing, implementation, maintenance, and control of teh organization's physical, relational, and object - oriented databases across multiple platforms and computing environments.
• Configuring Postgresql Streaming Replication and Pgpool for load balancing. Managing teh 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 wif Greenplum.
• Proficient wif 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 teh database performance and tuning.
• Check teh Accuracy of teh Data being updated and ensure Perfect Reporting and Verify teh 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 wifin teh organization.

TECHNICAL SKILLS:

Databases: PostgreSQL from 8.4.x to 9.5.x, Oracle 10g

Languages: Shell scripting, PL/PGSQL, Java, Python, C, C#, XML, HTML

Operating Systems: Linux, Unix, WindowsReplications Binary and Object level replications.

Operating System: Windows 2003/2000 Advanced Server, UNIX, Linux, NT Windows 9x.

Other: Microsoft Office word, excel, power point, outlook, MS Visio, Visual Studio 2005, 2003.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

PostgreSQL DBA

Responsibilities:

• Plans and coordinates teh administration of PostgreSQL databases to ensure accurate, appropriate, and TEMPeffective 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 wif PL/PGSQL.
• Expertise in trouble shooting teh database performance issues along teh wif 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 teh physical database environment. Evaluates and recommends teh 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 teh 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 dat meet client expectations for teh 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 teh 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 TEMPeffectively.
• Proactive in updating teh 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

Confidential - Sunnyvale, CA

PostgreSQL DBA

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 principals and practices, including planning, testing, backup/restore
• Responsible for all backup, recovery, and upgrading of all of teh 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 teh issues on gpcrondump and gpdbrestore. Fixing teh issues on External tables, gpfdist and gpload utilities.
• Fixing heap and Append-only table corruption issues.
• Recovering teh failed segment instances using gprecoverseg incremental and full recovery. Configuring and fixing teh Issues wif Pgadmin-III client application.
• Monitoring teh DB growth for every month in DWH databases and planning to implement teh table partitioning for better performance.
• Develop, implement, maintain policies and procedures and document database architecture to ensure teh security and integrity of teh 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 teh DB growth for every month in DWH databases and planning to implement teh table partitioning for better performance.
• Monitoring teh bloat repot on every table and performing maintenance wif minimal downtime.
• Experience supporting a mission-critical database environment wif 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 wif accurate time notifications.

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

Confidential - Santa Clara, CA

DBA

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 teh Index bloat concurrently to improve teh performance. Scheduled maintenance activities to vacuum, analyze to improve teh query response time.
• Maintaining custom vacuum strategies at table and db level. Query optimization and troubleshooting.
• Hosting Weekly calls for customers as per teh schedule.
• Close collaboration wif 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 teh development life cycle.
• Data migration while upgrading database versions ranging from 8.2 to 9.5. Troubleshoots wif problems regarding teh databases, applications and development tools.
• Performed Architectural Health Check (AHC) on client systems wif 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.

Confidential

DBA

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 halp 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 teh databases from Production to Test environment using Hot/cold/export/RMAN backups.
• User creation and providing necessary Roles, Privileges and quota as per teh requirement. Monitoring teh Table spaces and adding/resizing data files.
• Performing reviews on teh design and code frequently to ensure teh site standards are being adhered to.
• Evaluating releases of Oracle and its tools, and third party products to ensure dat teh site is running teh products dat are most appropriate.
• Installing new versions of teh Oracle RDBMS and its tools dat access teh Oracle database.
• Planning and implementing backup and recovery of teh Oracle database.