Database Administrator Production Support
Resume:
`
SANDEEP
Phone: 312-***-****
********.*****@*****.***
Sr. Database Administrator
PROFESSIONAL SUMMARY:
14+ years IT experience as an Application/Development DBA and Production Support DBA on various OS and cloud platforms.
3+ years of solid experience in PostgreSQL 9/11.9/13.5 Administration in Installing, Migrating, Tuning, Troubleshooting and Maintaining on VMware, AWS and Heroku.
Work closely with business analysts to understand requirements and develop, troubleshoot complex report queries, write FUNCTIONS, TRIGGERS (pgSQL and pgPL/SQL) on Postgres DB for reporting and monitoring purpose.
4+ years of extensive cloud CRM experience like Salesforce software, Salesforce object navigation. Managing users, Developing SOSQL, Apex code and Integrate Data between salesforce and Oracle using data integrator tools like TALEND Studio and salesforce Dataloader.
12+ years of experience in Oracle (11g/12c/18c/19c) RDBMS and RAC administration in Installing, Administering, Migrating, Upgrading, Tuning, Troubleshooting and Managing over multi-terra byte of databases on EXADATA, ODA, Linux, Sun Solaris, HP-UX, and Operating systems on Production, UAT, Staging, Development environments.
2+ yrs of Application DBA experience in Administering, Installing, Cloning, Patching Oracle EBS 11i /R12 on HP-UX and Solaris platform.
Experience in OLTP, OLAP and DSS database systems, implementing and managing Very Large Databases (VLDB).
Proficient in DBA responsibilities such as performing Installation, Upgrades, Patches, TAR support, Cloning, Backup and Recovery, Performance Tuning, capacity planning, Migration, script development, and documentation.
Excellent understanding of Oracle Internals, Architecture, Data Dictionary, Data Management, Automatic Storage Management (ASM) and System Management and EXADATA ZFS.
Good experience in SQL, PL/SQL, Shell Scripting (Korn, Bash), Logical and Physical Database Design, Backup and Recovery procedures.
Migrating on-Prem Oracle database to AWS RDS, EC2. Broad knowledge on AWS Services. Deploying and managing various AWS resources with AWS.
Configuring and managing Postgres 12.6 AWS RDS and VMware.
Excellent exposure to Dataguard, standby databases, materialized views, Oracle Spatial, transportable tablespaces and Virtual databases (VDB) using DELPHIX.
Proficient in monitoring database activities by using Oracle Enterprise Manager (OEM 10g/11g/12c), TOAD utility.
Excellent knowledge in datapump, Hot/Cold Backup and crash Recoveries of databases using RMAN on Veritas Net Backup, IBM Tivoli Storage Manager (TSM).
Setup of Oracle Enterprise Manager OEM Grid Control 10g/11g for database monitoring, performance, diagnostics. Complete range of Oracle DBA activities including day-to-day production database monitoring includes Alert logs, Trace files, Archive files, Troubleshooting production issues and Performance Tuning issues.
Scheduling and Troubleshooting Database performance issues using Statspack, Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
Efficient in SQL query Optimization using SQLTXPLAIN, explain plan, Utlbstat/Utlestat, TKPROF, Gathering statistics, Pinning objects.
Monitored Suspicious behavior of the database through Auditing (Privilege level, Object level, Statement level).
Provided Security for transparent data by enabling Encryption (TDE) for Tables, Columns and on entire Tablespace level by Creating Wallets.
Monitoring & Reorganizing Tablespaces/Tables/Indexes and Granted Users the resources by Creating Profiles, Managing Sessions, Privileges and Roles.
Configuring Oracle Audit Vault and Database firewall (AVDF),Oracle Database Vault, OEM Data Masking and Delphix Masking.
Knowledge in Administrating, Configuring OBIEE 10g/11g, Weblogic 11g, Oracle Goldengate 11g.
Extensive experience in all phases of software development life cycle (SDLC) and active member of software development teams in developing Relational Database Applications.
Attended EXADATA, ZFS and Oracle 12c workshops, HOTSOS Training and ORACLE training on Performance and 12c new features.
Enthusiastic, client support /communication skills, implementing best practices and eager to meet challenges and quick to learn and assimilate new concepts and ideas.
TECHNICAL SKILLS:
Operating Systems
Sun Solaris 10/9/8/7, IBM AIX 4.3.3/5.x, Red Hat Linux RHEL 2.1/3.x/4.x/5.x, HP-UX 10.x/11.x, and Windows 95/98/NT/2000/XP.
Databases
PostgreSQL 9/11.9/13.5/15, Oracle 18c/12c/11gR2 /11g/10g RAC, RAC with ASM and OCFS2, Oracle 9i RDBMS, SQL Server 2005/2008, MS Access, My SQL, Mongo DB,Cassandra. Azure flexible database server, AWS cloud database.
Languages
SQL-PL/SQL, PSQL-PLPGSQL,NOSQL, C,C++,Visual Basic, Unix Shell, PERL, AWK.
Networking
TCP/IP, Cisco Switches, Cisco Routers and Hub connections.
Web Languages
XML1.0, Cold Fusion 4.0, HTML, DHTML, CSS.
Tools/WebApp/Services
Oracle Application 11i/R12, AWS RDS AWS S3, Salesforce, Talend STUDIO, DELPHIX 5.2, Goldengate 11g, Fusion Middleware 11g, TOAD, Oracle Migration Workbench, PostgreSQL BART 2.5.4, OEM Cloud Control 13c, SQL-Backtrack, SQL* Loader, Erwin, Tivoli Storage Manager, Veritas Volume Manager, OBIEE 10g/11g, Web Logic 11g, Apache/IBM httpd .
Hardware/Storage
Exadata X6-2, X5-2, X2-2, ODA,VBlock 300GX, Sun Enterprise Servers (E10K, F15K), HP 9000, Intel based Compaq, EMC.
EDUCATION:
Bachelors of Technology in Electrical, Communication and Computer Engineering from JNTU, India.
(2002-2006)
Masters of Science in Electronics and Computer Engineering from Southern Illinois University Carbondale, IL, USA. (2007-2008) GPA: 3.33
TRAINING and CERTIFICATION:
Oracle certified Professional.
HOTSOS Training on Performance Tuning.
PROFESSIONAL EXPERIENCE:
DELOITTE, DENVER, CO Jan’ 19- Till date
Role: Senior DBA consultant/Developer
Description: TRAILS, CBMS and Child Support Projects.
Responsibilities:
Install and Configure Oracle 19c/18c/12.2 standalone and 2-Node RAC ASM Cluster on AWS RDS/VMware.
24X7 Production support and Development support for Oracle and PostgreSQL 9/11.9/13.5/15.5 databases running on AWS,Heroku.Azure.
Perform Oracle database Upgrades from Oracle 11.2.0.4 to 19c on to RHEL 6/7.
Perform database migrations from Oracle 10g on HP-UX to 12.2 RAC on to RHEL 6/7.
Configuring production Physical Standby RAC database ( Dataguard) for Production Disaster Recovery.
Developing jobs to Extract or Load Data between Oracle and Salesforce using Talend Studio.
Implementing Archive Purge strategy using for Oracle and Postgres db’s partitions.
Migrated Oracle databases from on-premise to AWS RDS PostgreSQL using Schema conversion tools (SCT) & Database Migration Service (DMS).
Configured Oracle Advance security features like AVDF (audit vault database firewall) for Oracle 19c Databases.
Migrated databases Exposure to Couchbase database User Management, Replication setup, DR testing, Index creations etc.
Managing Objects and Users on PostgresSQL,Mongodb, Cassandra databases. Postgres migrations from EDB to ERA and from Postgres 13.5 to Postgres 15. understanding of postgres replication like EFM and Patroni. Creating Postgres functions and Triggers to create reports and datafixes.
Implemented Database Vault and Audit Vault and defined appropriate realms and rules sets and Implemented Audit record Purge Strategy along with FGA Audit policies.
Migrating data between Oracle and Postgres db, point in time recovery using (BART) backup and recovery tool in Postgres. Fixing sync issues between standby in Postgres DB cluster.
Configured dSource and Virtual databases and Masking using DELPHIX .
Implementing DB security features like Unified Auditing, Encryption and MASKING PII data using OEM, DELPHIX and Custom scripts.
Configure Oracle Database Active Directory Authentication and CMU using KERBEROS authentication with Microsoft active directory.
Resolving production support tickets and applying and packaging new development tickets through JIRA and bitbucket.
Maintaining the DB standards as the code is sync and handling outages like password changes, Patching, Bouncing activities and network changes.
Integrate SALESFORCE data and Oracle data using Talend studio.
Helping developers with PGSQL functions and procedures with new changes and Enhancements on postgresql db and Salesforce.
Configured 12g Active Dataguard on production database to reporting database.
Configured OEM monitoring for the migrated database.
Environment: AWS,,Exadata X5-2, Oracle 19.7/12.2.0.1/11.2.0.4 RAC RDBMS, ASM, PostgreSQL 13.6/12.10/10/9, Salesforce, Talend 7.3, Goldengate 19.1,OEM 12.1.0.2/12.1.0.3, EXADATA 11.2.3.2, GGSCI CELLCLI, Linux 6.7, HP-UX, GITHUB, VMware, OEM, Opatch, Shell, RMAN,SQL/PLSQL, Toad 9, ASMFD, DELPHIX 6.0.13, COMMVAULT, Unified Auditing, AWS RDS, EC2, Heroku, Heroku Connect, Salesforce,BART 2.5.4.
DELOITTE, SANTA FE, NM Jul’ 13- Dec’ 18
Role: Senior Oracle DBA consultant
Description: ASPEN is the integrated eligibility solution for the State of New Mexico. ASPEN improves public access to services through the web and streamlines services by providing field staff with a more efficient and technically advanced eligibility tool. ASPEN eligibility system is used by approximately 1,500 users to serve 700,000 clients – nearly one-third of New Mexico’s population. ASPEN automates eligibility determination and benefits issuance for several public assistance programs and provides a tool for the workers in the offices as well as a Self-Service solution for citizens (Yes NM).
Responsibilities:
24X7 production support for 11gR2/12c Oracle RAC ASM databases on EXADATA Quarter Rack X6-2 and X5-2.
Configuring, Monitoring, Managing 11gR2/12c different Test and Dev Oracle databases on EXADATA X5-2.
Gather storage and server requirements and then Install and Configure 2-node 12.2 RAC CDB/PDB database on VMware for Dev environments.
Installing and managing MongoDB and MySQL dev databases for proof of concept on application migrations.
Configuring production Physical Standby RAC database ( Dataguard) for Production Disaster Recovery.
Configure Oracle Unified Auditing to simplify oracle audit management and Audit archive/purge strategies.
Configured and manage RMAN database backups to Disk, ZFS and Netbackup Datadomain.
Exadata management through ILOM, executing Exacheck reports, Sundaig and CELLCLI utility to collect information on Exadata and debugging all Exadata related issues with Oracle Support.
Cloning and Data Masking Production sensitive data on non- prod environments.
Implemented Oracle Advanced security options (ASO) for Tablespace Encryption.
Knowledge on Database resource management and IORM(Exadata resource management) for production databases.
Configuring Oracle Flashback and used Flashback table and Flashback database options during data corruptions in no-prod environments.
Implemented Database Vault and Audit Vault and defined appropriate realms and rules sets and Implemented Audit record Purge Strategy along with FGA Audit policies.
Implemented Interval Partitioning and Range partitioning with Hybrid Columnar Compression (HCC) for Archive and Staging tables.
Responsible for performing Goldengate POC to replace Active data guard to improve audit collection on reports database.
Resolved critical issues, Bug Fixes and worked over TARs, OWC sessions.
Environment: Exadata X5-2, X6-2, Oracle 12.2.0.1/11.2.0.4 RAC RDBMS, ZFS, ASM, OEM 12.1.0.2/12.1.0.3, Exadata 11.2.3.2, CELLCLI, Linux 5.4, VMware,AWR/ADDM, Datapump11g, ASO TDE, Data Masking, Data Vault, Audit Vault, Flashback, Opatch, Shell, RMAN, Netbackup 7, MongoDB, MySQL,Goldengate 11g/12c,SQL ADVISOR, SQLT,SQL/PLSQL, Toad 9, Erwin Data modeler.
AMERICAN BAR ASSOCIATION, CHICAGO, IL Apr’12- Jun’13
Role: Oracle DBA with EBS Consultant
Description: The American Bar Association is one of the world’s largest voluntary professional organizations. It is committed to doing what only a national association of attorneys can do: serving our members, improving the legal profession, eliminating bias and enhancing diversity, and advancing the rule of law throughout the United States and around the world.
Responsibilities:
24X7 production support for 11g/10g Oracle RAC ASM databases on Solaris 10 environment.
Configuring, Monitoring using OEM, Managing 11g/10g different Test and Dev Oracle databases on Solaris 10, RHEL 5.4.
Configured RMAN backups to disk and then to tape for all 10g/11g oracle databases including production.
Scheduled and Monitored Batch and Cron Jobs for RMAN and TSM on Solaris 10.
Installing, configuring OEM Cloud control 12.1.0.2 for database monitoring and maintenance.
Monitoring Tablespaces, Resizing, Relocating data files for better disk I/O.
Applied Quarterly security Patches (CPU/PSU), Patch set and One-off Patches on Oracle RDBMS and Grid.
E-Business Suite Apps 12.0.6 RUP4 on Solaris 10. Administration through AD Administration utilities task including Compilation, re-linking of executables, administration of workers, administration of concurrent managers and requests & maintenance including applying patches.
Refreshing EBS instance from Production to Test instance.
Installed and configured High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2 RAC environments.
Setting up GPG encrypted SFTP for EBS application for sending employee information and fetching employee expense reports and for single user access to corporate credit card programme.
Resolved critical issues, Bug Fixes and worked over TARs, OWC sessions.
Environment: Oracle 11.2.0.3/10.2.0.5 RDBMS, RAC 11.2.0.3, ASM, OEM 12c, Solaris 5.10, RHEL 5.4, Oracle Apps R12, AWR/ADDM, Datapump, Opatch, Adpatch, Adadmin,Adctrl, Shell, RMAN, Fusion Middleware 11g, SQL Server 2008, Windows 2000, DB Artisian, Goldengate 11g.
JOHNSON CONTROLS INC, MILWAUKEE, WI Aug’10- Mar’12
Role: Oracle Apps DBA Consultant
Description: Johnson controls is a global diversified technology and industrial leader serving customers in more than 150 countries. Worked for G12 Upgrade Project for Johnson’s controls which was a complex environment involving R12 EBS, Oracle 3 node RAC 11g and OBIEE as well as supporting their older version which was running on EBS 11i and Oracle 10g.
Responsibilities:
24X7 production support for 10gR2 RAC databases on HP-UX 11.23 environments.
Monitoring, Troubleshooting, Configuring 11gR2 RAC multi node databases with ASM for Global Lighthouse Project.
Installing 11.2.0.2 Grid Infrastructure (RAC), RDBMS multi node with ASM hosted on HP-UX 11.31 servers for development/test/UAT /Prod environments.
Upgrading two node RAC from 11.1.0.7 to 11.2.0.1 hosted on HP-UX 11.31 operating system.
Migrating non-ASM databases to ASM databases 11.2.0.2 on HP-UX 11.31.
Installing OEM Grid 11.1.0.1 and agents for database monitoring and maintenance.
Oracle messaging gateway (MGW) setup for advanced queuing (AQ’s).
E-Business Suite Apps 12.1.3/11.5.10.2 RUP4 Administration through AD Administration utilities task including Compilation, re-linking of executables administration of workers, administration of concurrent managers and requests & maintenance including applying patches.
Installing, Configuring E-Business Suite Apps 12.1.3 on HP-UX 11.31 operating system.
Cloning Oracle application, performing intense Patching activities and merge patches.
Advance topologies Installations of E-Business Suite Apps 12.1.3.
Monitoring E-Business Suite Apps 12.1.3 using OAM.
Expert level performance tuning of Applications, Concurrent Managers and Parallel Concurrent Processing setup.
Implementing incremental backup, recovery strategies on TSM.
Installing, Administrating Oracle Business Intelligence OBIEE 10.1.3.4.1 which includes Configuration of Multiple Presentation services, Clustering, Single Sign On on development and UAT servers for the BI Reporting team.
Integrated Oracle Business Answers 10.1.3.4.1 with BI Publisher.
Oracle Business Intelligence OBIEE 11.1.1.5 requirement gathering and installation for POC for BI Reporting Team.
Resolved critical issues, Bug Fixes and worked over TARs, OWC sessions.
Environment: Oracle 11.2.0.2/11.1.0.7 Grid Infrastructure and RDBMS, Oracle 10.2.0.5 RAC and RDBMS, ASM, OEM Grid Control 11.1.0.1/10g, HP-UX 11.23/11.31, Oracle Apps 11i/R12, OBIEE 11.1.1.5/10.1.3.4.1, AWR/ADDM, SQLTXPLAIN, Opatch, Adpatch, Adadmin, Shell, RMAN, Oracle Streams, Tivoli storage manager, Weblogic 11gR1(10.3.2), TOAD .
VERIZON VSO, ARLINTON, VA Nov’08 – Jul’10
Description: Verizon delivers the fastest, most reliable 4G LTE network in America. I was responsible for procurement of hardware for building a 2node Oracle RAC database right from scratch to support and maintain Verizon Multimedia Application Project.
Role: Oracle DBA Consultant
Responsibilities:
24X7 production support for Oracle 10gR2 RAC databases on Redhat Linux 4.7 environments.
Monitoring, troubleshooting 10gR2 RAC, 11gR1 RAC, 11gR2 RAC databases on ASM storage and OCFS2 on Production, Development, UAT, Staging environments.
Upgrading Two Nodes RAC from 11.1.0.7 to 11.2.0.1 on RHEL 5.4.
Suggested Server and Storage infrastructure needs for applications in both Spinco and Retainco versions. And prepared Architecture Diagrams with all related information’s.
Readdressing IPs for the RAC database servers and Standby Server when shifted to different data centers.
Implementing and Configuring SSL certification on all WebApp Servers.
Implementing Single Sign On (SSO) on Development and Testing server.
Proactively identified issues/bottlenecks that are potential problems, involved necessary support teams Application, Linux, Network, Storage etc. and took a corrective action to rectify the issues.
Implemented Transparent Data Encryption (TDE) for Tables, Columns and on entire Tablespace level by Creating Wallets.
Supported Java Developers and Testing Team with connection related issues and structural changes in the database.
Configured RMAN for scheduling backup directly to tape (Veritas NetBackup).
Scheduled and Monitored OEM Grid and Cron Jobs for RMAN and exports on Unix Platforms.
Took up a role as System Architect/Web Developer in Building Database and WebApp Servers for the new development and testing environments right from installing RHEL 5.4 OS, Installation/configuration of Apache httpd Webserver and Installing/Configuring/Integrating WebLogic 11g and later deploying application.
Environment: Oracle 11gR2/11gR1/10gR2 RAC, ASM, OEM Grid Control 10g, Redhat LINUX4.7/5.4, Dataguard, Performance Tuning, AWR/ADDM, Shell, RMAN, Veritas NetBackup, RDBMS, Apache httpd, WebLogic 10.3, TOAD.
Contact this candidate