SUMMARY

• Started as a hardcore oracle developer before becoming an oracle Database Administrator/Data Architect, and then an implementation consultant. Now I am a Senior Oracle Database and AWS Postgres RDS developer who is familiar with and great at helping in all of a system's areas.
• Have AWS solution architect associate certification, familiar with most of the services, worked with different RDS and experience in provisioning AWS services using Bash shell, Python, Ansible, perl and ruby using AWSCLI, API and SDK.
• Experience in on - prem Oracle EE to AWS cloud Oracle SE migration and Oracle EE/SE to AWS Postgres RDS migration.
• Having 32+ years of database experience as Production DBA and Development DBA, 30 years in Oracle and 2 years in AWS Postgres RDS. Experience includes in platforms Oracle Grid and RAC and Oracle Exadata.
• Experience in software engineering lifecycle such as analysis, designing, developing, testing and implementing applications Good knowledge in Finance, Material Management, Manufacturing, Payroll, Project Applications and ETL process. Deep exposure to Oracle Financial Applications and PeopleSoft (EPM, Financial and HR)
• Strong knowledge of Oracle and Postgres architecture and internals. Strong expertise in Oracle/Postgres Database and Application Performance Tuning.
• Very strong in database tuning and performance monitoring with Oracle AWR and database dictionary views (V$ and DBA views) and Postgres AWS RDS performance insight and pg catalog and information schema objects.
• Work as a team to implement better design and help extensively to rewrite the program/sql to improve the performance. Help trouble shooting by working with design and development teams.
• Experience in Modeling using ERWIN and SQL Developer modeler for logical, physical modeling and reverse engineering.

PROFESSIONAL EXPERIENCE

Confidential, Rockville, MD

Senior Cloud Database Developer

Responsibilities:

• Involved in conversion of Central Registration Depository (CRD) from Oracle EE to AWS Oracle RDS SE migration. Work includes Setup AWS RDS and DMS infrastructure using bash shell awscli calls, do one time create and restore data pump, setup DMS in CDC mode, make required changes to the objects during data transfer to improve the performance and data integrity. Develop linux/perl scripts to create data feeds for external users and setup jobs using JAMS/Appworx.
• Involved in conversion of Member Data Repository (MDR) database from Oracle EE to AWS Postgres RDS migration. Work includes convert ETL Datastage processes to functions and create Materialized Views and Tables for consumer use. Improved the performance of the daily and monthly processes to complete in scheduled window at night.
• Improving the performance of many PROCTOR reports based on large SQL that are migrated from Oracle database and Cognos reporting tool to AWS RDS Postgres functions.

Confidential, Reston, VA

Senior Oracle/AWS-PostgreSQL Developer

Responsibilities:

• Sr. Developer worked in an Oracle Exadata platform. Deep understanding of database server and storage server functions, how they are configured for OLTP and data warehouse systems with smart scan and flash cache. Involved in loading Student data and SAT, PSAT and AP exams data from vendors to CB database, calculate merit and metrics of students using advanced PL/SQL packages.
• One Year experience in AWS PostgreSQL and Oracle RDS that includes DevOps scripting using Ansible, Perl, Bash and Ruby for Infrastructure and Code deployment. Experience in converting processes from Oracle to PostgreSQL functions.

Confidential, DC

Senior Oracle Production DBA

Responsibilities:

• Primary DBA to support 2 Node RAC databases. This includes installation, upgrade and patching of development, test and production databases.
• Worked with developers on ETL processes and reports to improve performance of SAP data Integration processes and Business Objects reports.

Confidential, Bethesda, MD

Senior Oracle Production DBA

Responsibilities:

• Involved in 24/7 Production Support of Marriott’s numerous large databases of different applications that include PeopleSoft and Siebel. Involved in working with Application teams in Design, Performance Tuning and Data Migrations.
• Responsibilities include Grid/ASM/RAC and standalone Database installation, upgrade and applying patches. Implementing backup and restore procedures.
• Responsible for PeopleSoft EPM Data Warehouse database of terabyte size. Strong and highly successful involvement in Database and Applications Performance tuning of Central Data Warehouse database, Feeder OLTP Peoplesoft databases, Cognos and other reporting databases.
• Installation, configuration and upgrading of Oracle server software in HP-UNIX. DBA tasks include experience in Replication and Partition.

Confidential

Senior Oracle Production DBA

Responsibilities:

• Installation, configuration and upgrading of Oracle server software in UNIX and Windows Server. Responsible for Oracle 8i to 9i migration. Evaluated Oracle features and Oracle related products.
• Responsible for all production and development databases, primarily very large Finance and HRMS PeopleSoft databases. Involved in database and application tuning and successfully reduced many processes from many hours to minutes.
• Involvement in code migration, database change management through the various stages of the development life cycle.
• Worked in Peoplesoft development using PeopleTools, PeopleCode, Application Engine and SQR. Worked as a member of the team that successfully converted Peoplesoft Version 7.5 to Version 8. Involvement in Peoplesoft administration.
• Working with Peoplesoft Functional and Technical Teams in Complete Design, Development and Testing environments.
• Responsible for Costpoint Federal projects accounting system: installation, upgrade and maintenance. Also, responsible for Oracle database, Weblogic server and Impromptu Administration.
• Strong experience with Virtual Private Database, implemented in a multi-organization project system to restrict users from other’s data.
• Responsible for all production and development databases running under Sun Solaris and NT with CITRIX middle-tier. Includes all DBA activities and remote database management. Also, responsible for application installation, upgrade and apply patches. Responsible for installation, logical and physical design, implementation and maintenance of development, test and production databases.