SUMMARY:

• 17+ years of total IT experience as a Database Architect, AWS Cloud, Certified PostgreSQL DBA (9.1.1 to 10.0), Oracle DBA (7.x to 12.2.x), Redshift DBA (1.x), Oracle Golden Gate (10.2 to 12.1), Oracle Enterprise Manager 11g/12c, Informatica ETL, Data warehouse Administrative Console (DAC), Business Analytics Warehouse (BAW), Unix/Linux Shell Scripting
• Confidential Cloud including administration, designing and configuring cloud considering business needs, future forecasting and cost estimation using services (RDS, EC2, EBS, EFS, EMRFS, Redshift using STL/SVL, Encryption, DNS IAM, ELB, Auto Scaling, VPC, Peering, Lambda, ECS Docker, BeanTalk, Cloud Front, Cloud Trail, Cloud Watch, SQS, SNS, SWS, STS, Route53, S3, WLM, Multi - AZ, Multi-region Network setup, Dynamo DB, Workgroup, Import/Export, Trusted Advisor, OpsWork etc.)
• Database Migration from DB2 -> PostgreSQL, Oracle -> PostgreSQL, PostgreSQL -> Confidential Redshift and Oracle -> Oracle from In-Premises to Confidential Cloud (EC2, RDS) using Ora2PG, PL/PgSQL, Oracle scripts, Bash shell Scripts, AWS DMS, SCT, Kinesis Firehose, Pipeline ETL.
• PostgreSQL DBA experience in installation, configuration, Replication (physical/logical), Stand-by Read Replicas, backup, recovery (upto table level), performance tuning, vacuuming, auditing, privileges, upgrade (Major and Minor), foreign data wrapper, debugging and troubleshooting in in-premises Hybrid environment and in Confidential Cloud on Linux and Windows platforms.
• Oracle DBA experience in Installation, upgrades, maintenance, backup & recovery (Data Pump, Hot, Cold, Logical and RMAN using Full, Partial, Until Time/SCN), Performance Tuning (Tkprof, Explain plan, AWR/ADDM reports, Advisers), refresh, cloning (OEM, Manual), troubleshooting (OEM, Toad, scripts, cron job), Oracle Standby/Data Guard (Physical, Logical, Snapshot, Active Data guard), Upgrades (Manual, DBUA) of Oracle application and Oracle core databases
• Golden Gate Administrator including Installation, Configuration of Extract, Replication, Manager, trails, parameters. Troubleshooting and fixing issues of LAG, Mapping, performance etc.
• Provided round the clock support to 2618 databases having 668 productions.
• Working knowledge of Mongo DB, Cassandra DBA (2.0.2 to 3.10), Oracle Exadata (12c) and Oracle Warehouse Builder (OWB) Administrator
• Domain knowledge of Retail (Retek - subsidiary of Oracle), Government, Telecom, Transportation, Civil Engineering and Banking applications

TECHNICAL SKILLS:

Database: PostgreSQL 9.1.1 to 10.0, Oracle Core7.x/8.x/9.x/10g/11g/12c, Oracle RAC 10gR2/ 11gR1/ 11gR2 / 12c, BAW, Confidential Redshift, IBM DB2

Languages / Tools: Unix Shell Script, Psql, SQL*Plus, PL/SQL, PL/PgSQL, Pro*C, Fortran, C, C++, Python, AD Utilities, OEM, dbconsole, Tivoli, Oracle RAC, Java, JDBC, RMAN, AWR, ADDM, ASM, ACFS, Statspack, Tkprof, Data guard (Physical, Logical, Snapshot), Server Manager, SQL*Loader, dbca, AWS S3/ EC2 / DMS / IAM / SNS / SCT / Pipe, Pgadmin III, IV, Postgres EDB, Rapid wiz, Kintana, RetekRMS9.x, GGSCI, Oracle Golden Gate Director, Veridata, Toad, OWB, Informatica ETL, Informatica Power Centre, Data warehouse Administrative Console, BIApplication7.9.6.3, Business Analytics Warehouse (BAW), Erwin

Operating System: Windows Server 2003/2008, Windows2000/98/95/NT/Vista/XP, MS-DOS, UNIXAIX, Sun Solaris, HP-UX, Linux Radhat, Confidential AWS Cloud

Domain Knowledge: Banking, Finance, Retail, Travel, Government, Civil Engineering, Cloud

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

Database Cloud Architect and DBA

Responsibilities:

• Database Migration from Oracle -> PostgreSQL using Ora2PG, PL/PgSQL, AWS DMS, SCT
• Data migration from DB2 -> PostgreSQL (EC2, RDS) and setup/configuring applications with in-premises active directory access. Created Unix Shell, Python and PL/PgSQL scripts of loading data and test cases using PostgreSQL utilities, AWS Pipeline ETL
• Database Migration from PostgreSQL -> Confidential Redshift (dc1.large 16 nodes cluster) and Oracle -> Redshift, (ds2.xlarge 28 nodes) using AWS DMS, SCT, Kinesis Firehose, Pipeline ETL.
• Upgrading to PostgreSQL Version 10.0, setting related configuration parameters, migrating existing partitions with Inheritance to Native Range/List partition tables and changing automation scripts as per new / changed features / Syntax of PostgreSQL version 10.0
• Created Table Level Logical replication in PostgreSQL version 10.0 using Publication and subscription at Primary/Secondary PG databases.
• Physical replication, backup, recovery, WAL archive setup/monitoring of multiple PostgreSQL databases.
• Scheduled data loading from multiple sources into Redshift using Kinesis Stream.
• AWS cloud architecture design / setup and configuration with EC2 instance, VPC, S3 including data lifecycle management, Security groups, Alert and notifications (SNS, SQS, Cloud Watch, 53), privileges and encryption for devp, UAT and Production database servers of PostgreSQL
• Data modeling (Logical, Physical, Reverse Engineering) using Erwin, Toad and PgModuler
• Performance tuning of highly busy databases in peak hours using pgpool and modifying/ scheduling database jobs and Linux cron jobs.
• PostgreSQL database (version 9.2.18 till 10.0) creation/configuration/maintenance into local and AWS cloud storage following Maryland State and agency level policies, rules and security.
• Standby setup/configuration of PostgreSQL from In-house Redhat Linux server to AWS cloud.
• Linked Oracle database tables into PostgreSQL database using Foreign data wrapper oracle fdw
• Resized the Redshift ds2.xlarge cluster from 8 Nodes to 12 nodes and setup/changed the parameter group, table sort key etc.
• Setup/ configure AWS IAM roles, performance tuning, encryption with Redshift cluster.
• Used Copy and Unload data to/from Redshift database between In-Premises and AWS.
• Supporting Redshift Database using STL, SVL, STV, SVV system tables/views, Unload into S3/ In-Premises, Copy from PostgreSQL, Schedule ELT from multiple sources using Kinesis Stream
• Creating/ Monitoring WLM queue group, user groups in Redshift with respective slot/memory of concurrent queries.
• Supporting 24/7 oncall on rotation basis for all UAT/production databases

Confidential, Madison, WI

Senior Database Consultant / Administrator

Responsibilities:

• Day to day management of hybrid database architecture and administration in cloud and in-premises infrastructure.
• Database architecture planning, design, cost optimization, setup, configuration, troubleshooting, bug fixing.
• Worked with different teams to re-design existing configuration.
• Database server setup/ Initialization, directories/path configuration. Database Server startup/ shutdown, Managing tables, indexes, schema, partitioning, Inheritance, constraints, views, functions, operators, standby configuration.
• Day-to-day administration and support of Database Cluster grid
• Debugging and troubleshooting database startup issue, connection/fork process and authentication (ident, peer, radius, PAM, certificate etc.) /role issues, kernel issues on Hp-UX and Solaris platforms.
• Logical, physical, RMAN Backup/ recovery, scheduling and monitoring.
• Database infrastructure support (Storage utilization, IP, DNS, Firewall, Regulatory/Non-Regulatory)
• Oracle Database hardware migration from Physical to Virtual environment. From HP-Ux to Linux environment using RMAN and Golden gate replication.
• Multiple Nodes RAC support (service, listener, srvctl instance level, service, listener ) using ASM
• Database upgrade 10.x / 11.2.0.3 to 11.2.0.4 / 12.1 and quarterly CPU, Java Patching.
• Active Data guard setup, Application database support, Linux/ Unix scripting
• Database Cloning using RMAN Duplicate and OEM
• Golden gate replication setup/ monitoring / error fixing at Object, schema and database level.
• Creation/ Maintenance of Oracle Wallet.

Confidential

Oracle and PostgreSQL DBA

Responsibilities:

• Worked as a Senior Oracle and PostgreSQL DBA in Redhat Inc to support multiple Production and development Oracle Core and Application databases, including third party client’s databases and have been part of the team of transferring data from 8 databases into a single Business Analytics Warehouse (BAW) using Informatica ETL and Data warehouse Administrative Console (DAC).

Confidential, Sunnyvale, CA

Oracle DBA/ Golden Gate Administrator

Responsibilities:

• Worked to support databases of third party

Confidential

Deputy General Manager

Responsibilities:

• I worked as a Deputy General Manager (DGM) in Process Management & Systems, responsible to support and maintain all departmental database processes.
• Have done all the requisite tasks (like presentation, meeting with concerned authorities, liasioning, creating project proposal etc.) to take 2 projects one from Ministry of Education (Delhi Govt) for construction of 10 Primary school building and another from FCIL (Food Corporation of India Limited).

Confidential, Salt Lake City, UT

Designation: Offshore DBA Lead /Principal Consultant

Responsibilities:

• Worked to support databases of SAM application in SQL Server 2005/2008 and Oracle Core 10gR2/9i.