SUMMARY

• Around twelve years of IT experience as a DBA(Oracle, PostgreSQL, MongoDB, Versant and Sql Server DBA) on a variety of platforms - UNIX (Solaris, Linux, HP-UX), AWS, Azure, Windows.
• Significant experience in Oil, Financial, Insurance, Transportation(Public) and Trading applications.
• Experience in implementing and managing Oracle 10g/11g features like Real Application Clusters (RAC), Data Guard, Streams and worked extensively in OLTP and OLAP environments.
• Proven hands-on cloud migration solution design/delivery experience.
• Database migration from Oracle and Teradata into PostgreSQL Database using SVC, DMS and Ora2pg.
• Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.
• Administration of PostgreSQL multi node clustered and replicated environments.
• Monitoring of system performance utilizing PgAdmin and command line tools.
• Maintained custom vacuum strategies at table and db level for performance.
• Configured log analyzation using pgbadger.
• Established and documented the PostgreSQL technology stack including standard operating procedures including startup/shutdown, backup/recovery.
• Implemented automated methods and industry best practices for daily data load(complete refresh) with help of ETL developers.
• Manage backup and recovery functions for a PostgreSQL reporting data warehouse environment
• Setup alerting mechanism for both PostgreSQL database and supporting environment to ensure system health and maximum availability.
• MongoDB Database Administration on both AWS cloud and on-premises.
• Installed OEM 12c and Migrated 79 servers containing 427 databases.
• Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.
• Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.
• Exposure on Azure cloud services Database Migration Service (DMS) and Ora2pg, AWS Database Migration Service (DMS).
• Experience in upgrading and migrating various versions of Mongo database on different platforms.
• Familiar with MongoDB architecture to improve performance and scalability.
• Familiar with MongoDB clusters, Java scripting to load unstructured data into sharding environment.
• Experience in using MongoDB data models document, key-value & wide column, or graph model.
• Installation, Configuration and Administration of Oracle10g/11g RAC by using ASM.
• Proficient in SQL, PL/SQL, Query/application tuning using optimizer hints, Explain plan, SQL trace, TKPROF, Analyze and Autotrace.
• Worked on various Technologies in Data warehousing - ETL Tool Informatica, Ab initio and database development tools like TOAD, ERWIN, and SQL Developer.
• Setting up Golden Gate requirements and using best practices.
• Experienced in designing, developing, monitoring and scheduling (using crontab) UNIX shell scripts to administer all the environments.
• Database backup and recovery. Used hot and cold backups. Involved in development of scripts to automate backup and recovery procedures for development databases.
• Extensively involved in Database Cloning manually as well as using RMAN.
• Good experience working with various FTP protocols like FTP, SCP using SSH protocol.
• Extensive Database Administration - Oracle 8i/9i/10g/11g/12c experience that includes creation and management of users and their profiles. Tuning of the database for optimum performance.
• Documentation of projects, databases, installations.
• Experience in working with high-transacted OLTP systems.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies. Strong interpersonal and communication skills in dealing with customers.
• Excellent troubleshooting skills and committed follower of Oracle Technologies.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g/12c, DB2 EE/EEE V 9.5, 8.x, 7.x/ESE 11.1/10.5/10.1/ UDB, Teradata, PostgreSQL 9/10, MongoDB 3.2/3.4/3.6, SQL Server, My SQL, DB2, Ms-Access

Oracle and other DB related Tools: SQL*Loader, SQL*Net, OEM,TOAD, ER-studio, Oracle migration work bench, Oracle Parallel Server, Oracle Replication, OID, Data Guard, ASM, Golden Gate, Oracle Data Integrator, RAC, OLAP, SQL backtrack and DevOps tools.

Operating Systems: Z-Linux, Sun Solaris, HP-UX, AIX4.3.3, Red Hat Linux 7.2, and Windows Server 03/08/12/16, AWS, Azure.

Languages: VB6.0, C, Pro*C, SQL, PL/SQL

Scripting Languages: Shell scripting, VB script, JavaScript, Perl

Markup Languages: HTML, XML (knowledge).

Web Servers: IIS, Apache, IBM

Server side Tools: ASP, PHP

Reporting Tools: MS Project, Ms-Office, MS-Visio, MSBI, VERITAS, Informatica, Ab Initio, oracle warehouse builder.

PROFESSIONAL EXPERIENCE

Confidential, Franklin Lakes, NJ

PostgreSQL DBA

Responsibilities:

• Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures.
• Import of Reports to PostgreSQL from Oracle, Teradata, DB2 Databases.
• Table Partitioning based on application requirement.
• Administration of 9.6/11 (20+ DB’s. Data Ingestion, Data Model optimization, Table/Index Optimization.
• Backup/Recovery, Performance Tuning, Data loads, Connectors to other environments, SQL Tuning.
• Optimization management of Query, Storage, Index, - Data Analytics Optimization.
• Maintained custom vacuum strategies at table and db level for performance.
• Configured log analyzation using pgbadger.
• Automating monitoring scripts as a proactive measure to check DB health regular bases.
• Creating roles, individual and generic users for each application.
• Vacuum and Analyse tables as per the need of the application.
• Planning and implementing regression testing after upgrade and release.
• Designing tables and partitions based on the application requirement.
• Performance tuning Sqls and Databases as and when required.
• Ability to proactively identify, troubleshoot and resolve live database systems issues. Knowledge in database design including logical and physical design.
• Ability to thrive in a fast-paced, deadline-sensitive environment. Responsible for configuring, integrating, and maintaining all Development.
• QA, Staging and Production PostgreSQL databases within the organization.
• 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.
• Providing response for all system / database issues on 24 x 7 Schedule responding to critical events and situations outside normal work hours.
• 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.

Environment: PostgreSQL9/10, Azure, DB2 Mainframe Z/Os, Teradata, MongoDB 3.4/3.6, AIX, RHEL 7, Agile, Confluence, ServiceNOW, DevOPS, Jenkins, Chef, PgAdmin, Teradata Studio, Shell Scripting.

Confidential, Jersey City, NJ

Oracle/PostgreSQL DBA

Responsibilities:

• Contracted to provide expert judgment, establish integrated change control processes and to direct and upgrade almost 45 databases and related projects, software and security updates, regulatory compliance and state mandated code changes, application enhancements, data quality audits, data extracts and modernization projects.
• Configuring and fixing the Issues with Pgadmin-III client application. Responsible for monitoring environments using monitoring tool viz. Nagios.
• Installing and configuring new servers as per customer's request. Cloning the Development, test and UAT environments with production data as per customer's request.
• Migrating databases from Oracle to Postgres.
• Develop and enhance scripts to automate and execute various DBA tasks.
• Successfully upgraded 11G RAC and standalone databases to Oracle 12C
• Co-ordinated with all application owners who use the databases to pursue the upgrade project.
• Planned and implemented the database upgrade to 12c for both compatible and incompatible applications and third-party tools.
• Sizing of Oplog based on Workloads and to maintain replication properly across all the nodes.
• Changed priority of replicaset nodes to keep Primary on specific data nodes.
• Maintaining Sharded cluster availability and security across all the nodes.
• Implemented a very aggressive patching schedule with applying quarterly Oracle CPU (Critical Patch Upgrades) on most databases and performed database upgrades whenever deemed necessary to improve our applications.
• Secure MongoDB using authentication.
• Documenting MongoDB installation, operations, security, auditing multiple environments.
• Wrote services to store and retrieve user data from the MongoDB for the application on devices.
• Developed a highly secure database user's environment by implementing tight profiles, roles and managing database sessions.
• Automated Upgrades and patches using Jenkins and Chef configuration management.
• Assisted Admins in installing Oracle clients and OJDBC drivers to make the existing application compatible to 12C.
• Constant monitoring of database space and space management
• Designing, Implementing Oracle Golden Gate replication solutions to client.
• Setting up of Oracle and Application user accounts and passwords, monitoring application security
• Responsible to improve the performance by Using the Hints, Indexes, Explain Plan.
• Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space
• Help developers writing database triggers, packages, procedures, functions, utilities for application development.
• Export and Import of User, Tables and Database using exp/imp and Data Pump.
• Involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
• Participated in the implementation of Data Encryption both TDE Inflight and At Rest.
• Initiated cronjobs to review alert logs and dump files to check for any ORA- errors.
• Performed Database Administration using TOAD, Oracle Enterprise Manager and SQL scripts.
• Documented the 12C upgrade for each database including all the necessary steps which were applied based on the requirement and troubleshooting issues.
• Designed the regression testing for each database with all jobs and performance respectively.

Environment: Oracle 12C/11g, PostgreSQL, DB2 Mainframe Z/Os, AWS,Aurora, ADABAS, IBM Data Studio, Ora2pg, SQL and DB2, MongoDB 3.4/3.6, RAC, OEM 12C, PgAdmin, ASM, MongoDB 3.0/3.2/3.4, AIX, RHEL 7, PL/SQL, RMAN, Jenkins, Chef, RAC, MSBI, SQL Server, GoldenGate, DataGuard, TOAD, TDE, Shell Scripting.

Confidential, The Woodlands, TX

Database Administrator

Responsibilities:

• Responsible for Database Administration for day to day operational support of Oracle, PostgreSQL, and Versant databases as well.
• Ensuring that database backups of different environments are being taken successfully.
• Designed and Implemented Sharding and Indexing Strategies for MongoDB servers.
• Extensively worked with Mongodump, Mongoexport/import, Mongostat, Mongotop, MMS tools.
• Designed MongoDB replica sets and multi-sharded cluster. Experienced in upgrading 3.2.x databases to 3.4.x.
• Designed and developed load balancing Mongo applications.
• Set up and configured MongoDB Cloud/Ops Manager for monitoring and backup/recovery.
• Experience in SQL, PL/pgSQL, including stored procedures, functions, triggers, and views.
• Exposure on AWS Database Migration Service (DMS).
• Scheduling jobs and troubleshooting in case of failure.
• Performing restores and data refreshes as per the requirement using impdp/expdp and sqlplus.
• Run scripts to create database objects and data manipulation as required.
• Responsible for performance upgrades to newer DBMS versions or preparing upgrades to newer DBMS versions or preparing an application to upgrade itself.
• Wrote monitoring scripts for Golden gate, general maintenance scripts for daily automation tasks.
• Troubleshooting, Performance Tuning Golden Gate issues
• Documented Design and change management for all process.
• Manage sharing of resources amongst applications.
• Primary DBA for 84 databases and responsible for all quarterly refreshes, upgrades, patches, monitoring and administration.
• Database and schema refreshes using impdp/expdp, imp.exp, Cold clone and RMAN duplicate very often.
• Performance tuning including database and SQL tuning to improve performance using tools like AWR, ASH, Explain Plan and thereby gathering stats, creating indexes, hints and altering parameters whenever required.
• Assisted in logical and physical database design.
• Installed, upgraded and patched Oracle software and associated applications.
• Wrote PL/SQL procedures, triggers and functions to enable plug and play of multiple data sources.
• Trained a new DBA in our environment.
• Participating in on call rotations supporting more than 2500 oracle and versant databases.

Environment: Oracle 12C/11g/10g/9i, PostgreSQL, PgAdmin, OID, OEM 12C, ASM, SVN, GoldenGate, DataGuard, MongoDB 3.2/3.4, Hadoop, AWS, Windows Server, AIX, Linux, HP-UX, PL/SQL, RMAN, Azure, Versant 6.4/5/6, SQL Server, SAP, Upstream, Downstream, TOAD, SQL Loader, Shell Scripting.

Confidential, Durham, NC

Database Administrator

Responsibilities:

• Demonstrated experience in performing Oracle Database Administration activities on large multi-Terabyte and highly critical environments.
• Primarily involved in providing production support of DB2 UDB databases on AIX and Linux servers.
• Implemented automated backups, Space monitoring, moving db2diag.logs, monitoring size of table spaces by setting up a threshold.
• Migrating databases db2 v8.2 to db2 V9.5 versions on AIX servers.
• Involved in Importing and Exporting data and database structure using db2look and db2move utilities.
• Performing database security audit reviews by using db2cops and db2shc tools and removing all the violations.
• Troubleshooting database issues and quickly resolving them.
• Advanced SQL Tuning and optimization to gain performance data warehousing.
• Creating of Shell scripts to automate monitoring SQLs.
• Introducing advanced SQL/PL*SQL methods pertaining to exadata.
• Incorporating existing monitoring, access, and access mechanisms into the Exadata environments.
• Consulting with business units to assess needs and recommends appropriate DBMS operational and warehousing methods and tools.
• Administered Oracle Access Manager (OAM) Single Sign-On authentication for user logging in Oracle 12c Cloud control.
• Documenting all the processes/procedures
• Maintaining quality service by establishing and enforcing organization standards
• Rolling out new application code / builds in various production and non-production environments.
• Performance tuning, problem research/resolution, code reviews and deployments, Oracle SQL support, and data movement.
• Partitioning tables with 26 billion records and 4 billion records to gain performance.
• Monitoring the database health and performance.
• Designing and implementing refreshing data using impdp/expdp, RMAN duplicate command, Backup strategies and DR.
• DBA on call every Thursday.
• Providing grants and restricting developers from consuming temp tbs and undo usage as well as running parallel slaves.
• Implemented data movement from Oracle to Hadoop and vice versa.

Environment: Oracle 11gR2/12C, DB2 EE/EEE V 9.5, 8.x, 7.x, Web sphere, RAC, OEM 12C grid control, ASM, Exadata, AIX, PL/SQL, RMAN, GreenPlum, Hadoop, GoldenGate, DataGuard, TOAD, SQL Loader, Shell Scripting.