SUMMARY

• Experienced DBA over 10 years of focused experience in IT industry in various fields like banking, insurance, financial, retail and manufacturing.
• Extensive experience in relational database design, analysis, modeling, development, administration, implementation, trouble shooting and quality management in Amazon Web Services Cloud and Devops
• Comprehensive experience as Oracle DBA; proficient in Oracle 8i/9i/10g/11g/12c Software Installations, Migrations, Database Capacity Planning, Automated Backup Implementation, Tuning Oracle 11g/10g/9i/8i/8.x/7.x on Unix and Windows NT platform.
• Involved wif architect group in designing teh logical and physical model of teh databases.
• Has good experience in UNIX administration, Shell scripting.
• Has impeccable communication and interpersonal skills and an exceptional team player.
• Managing teh team of Oracle DBAs and collaboration of AWS and Devops Team wif active coordination wif teh end user community.
• Managed environments like DEV, QA, UAT and PROD for various releases and designed instance strategies and CI/CIT/CID integration.
• Extensive experience using MAVEN, ANT and Xcode as build tools for teh building of deployable artifacts from source code.
• Extensively worked on Hudson, Jenkins and Anthill Pro for continuous integration (CI) and for End - to-End automation for all build and deployments.
• Experience in Amazon Web Services (AWS) for database storage, analytics, application, and deployment services, content delivery and other functionality for teh TEMPeffective businesses scale and growth.
• Experience in implementing real application cluster Oracle 12c/11g/10g RAC.
• Experience in Disaster recovery support using Data Guard. Proficient in Delivering Oracle Database performance-tuning services for customers wif Explain Plan, TKPROF, STATSPACK, SQL TRACE, custom scripts and wait interface. Knowledge of teh Oracle Gloden Gate installation, configuration, troubleshooting GG issues.
• Experienced in Troubleshooting and resolving critical production issues in complex application environment: SQL*net connectivity issues, locking, OS/network issues.
• Creating Oracle complex stored procedures and views for ETL process, creating SQL*Loader scripts and Oracle external tables.
• Excellent noledge on Oracle 11g/10g features like AWR, ASM, 10g Grid monitoring.
• Worked wif development teams and data administration staff to enhance Database and application performance.
• Experience in backup and cloning using RMAN procedures.
• Experience in Data Migrations using oracle export/import, Data Pump, SQL*Loader.
• Proficient in using OEM 11g/12c and Oracle Grid Control.
• Experience in Proactive monitoring, identifying areas dat need to be improved in teh application and database.
• Expertise includes management of schemas, objects & partitioning teh tables & indexes.
• Providing Solutions to teh Problem Faced by end Users or Programmers.
• Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.
• Experience in various Oracle Financial applications like PeopleSoft, Oracle EBS etc.
• Worked in various financial modules like Oracle Assets, Oracle General Ledger, Oracle Payables, Oracle Receivables and Oracle Cash Management.

TECHNICAL SKILLS

Operating System: Red Hat Linux, Solaris, HP-UX, AIX, Windows.

Databases: Oracle 8i/9i/10g/11g/12c, RAC 10g/11g MS- Access, NoSQL, SQL, Server 2000/2005/2008, DB2, Teradata.

Programming Languages: SQL, PLSQL, Java, C, C++, XML, HTML, ASP.NET, C#, UNIX shell

Web Servers: Web logic JBOSS, Apache Tomcat, IntelliJ IDEA, Oracle Web logic.

Tools: and Utilities (ORACLE) Import/Export, Data pump, SQL * Loader, SQL Trace, OEM, Explain, Plan, STATSPACK, AWR, ASH, ADDM, RMAN, FTP, TKPROF, Gloden Gate, Streams.

AWS Tools: Amazon CloudWatch, AWS CloudFormation, AWS CloudTrail, AWS Config, AWS OpsWorks, AWS CodeStar, AWS CodeCommit, AWS CodeBuild AWS CodePipeline, AWS Cloud9. EC2, VPC, S3, ECS, IAM, Route 53

Devops Tools: Jenkin, Docker, Ansible, Git, Maven, Chef, Vagrant, Puppet.

Other Tools: ERWIN, DB Visualizer, Microsoft Visio, Use cases, SQL Developer, OEM, VM Ware, FileZilla, putty, TOAD, Query Builder, VNC, WINSCP, APEX, Splunk, Dynatrace. Ant, Maven.

PROFESSIONAL EXPERIENCE

Confidential, Sacrament, CA

Senior Oracle DBA

Responsibilities:

• Database design, master data management, maintenance and editing wifin a variety of systems.
• Provided 24x7 on call production support to troubleshoot complex and sometimes cross-platform issues.
• Extensively used datapump, which is a feature of Oracle 11gR1 throughout teh project.
• Capture technical requirements, coordinate wif other system managers/administrators, and develop solutions for data exchanges to include web services.
• Implementing backup and recovery procedures including logical backup (RMAN), physical backup (online/offline) and integrating teh backup procedures.
• Assist wif developing methods and solutions to increase data quality.
• Assist team members wif internal requests for data, mapping, and analysis.
• Assist in teh evolution of a maturing data model, including geospatial elements.
• Strong programming experience in PL/SQL and UNIX shell scripting.
• Scalability/HA solutions included Oracle RAC, implemented and supported Shareplex for Data replication, supported Oracle Gloden Gate Replication and Active Standby (11gR2).
• Maintained users, roles and privileges in Oracle database for teh development team.
• Extensively used Performance and Tuning tools like AWR, ADDM through out teh project both in command prompt and 12c OEM interface.
• Applied Smart Scan, Flash Cache, Hybrid Columnar Compression IORM in Exadata.
• Expertise in Oracle 11g, Oracle Exadata, RAC, Data Guard, ASM, RMAN, PL/SQL, OEM, Oracle • Enterprise Linux, HP-UX
• Performed Installation, configuration, troubleshooting Oracle RAC Database in 11gR2.
• Assisted in disaster recovery procedures and recovery using Data Guard in both 11gR2 and 10g.
• Responsible for Performance monitoring and tuning teh database using OEM, AWR and ADDM analysis.
• Carried out disk space maintenance on various UNIX servers. Provided suitable mount points for each database and additional disk space for testing purposes.
• Worked in various financial modules like Oracle Assets, Oracle General Ledger.
• Provided Oracle installation support, database maintenance, version control for source code and backup using RMAN wif new features of 11gR2.
• Set up Apex environment and SSL configuration.
• Worked in Agile environment and Devops infrastructure automation tools like Chef, Puppet and Ansible.
• Participated in various System Task, Database Task, and Log Tasks.
• TEMPEffectively used Datavail for DevOps environment set up and for teh optimization for continuous database deployment, supported by regular database assessment, monitoring, and tuning.
• TEMPEffectively used Amazon RDS for teh proper access of teh database log files instead of connecting to teh host using AWS CLI.
• Using Amazon RDS automated backup feature participated in delivering point-in-time recovery (PITR), which halps teh restore process.

Environment: Oracle 12c RAC/11g RAC/9i, Red Hat Linux 4.x, Solaris 10, Sun v480, HP-UX11, AIX 5L, Windows NT/2000, TOAD 8.6, ASM, EMC, Oracle Enterprise Manager, Erwin 4.x, Visio, Warehouse builder, Data Guard, RAC, RMAN, TKPROF, SQL-Trac

Confidential, Dallas, TX

Senior Oracle DBA

Responsibilities:

• Developed, reviewed and enforced database standards.
• Backed up and Recovered of large databases RMAN as well as Netbackup.
• Involved in Oracle database performance tuning and troubleshooting.
• Troubleshooted database performance issues and also halp teammates understand teh resolution process.
• Ran various AWR, ASH reports and 10046, 10053 trace files to identify potential performance problems.
• Applied SQL statement tuning skills.
• Worked independently as well as excellent interpersonal communication skills.
• Checked disk group’s space and limitation in a RAC environment.
• Checked Volumes Information in each RAC instances.
• Expert in Production Oracle 10g/11g environments including RAC, PL/SQL, OEM, RMAN, Data Guard and shell scripting.
• Responsible for DBA functions and ETL development in Data ware housing.
• Teh ability to spot potential problems from AWR reports and teh noledge to propose appropriate solutions.
• Mentor database team and developers on new database technology, provide database design and architecture oversight.
• Developed PL/SQL scripts for Extraction, Transporting & Transforming (ETL) data from Production databases to Data Warehouse Databases.
• Worked in Linux, Solaris, and AIX operating systems.
• Participated in various data replication like Active Data Guard, Streams and/or Glodengate.
• Involved in installation, administration and troubleshooting Oracle Gloden Gate.
• Able to prioritize and execute tasks in a 24 x 7 production environment.
• Worked wif development teams on all aspects of database design including tables, views, stored procedures, packages and manage role-based grants.
• Involved in Glodengate installation and troubleshooting.
• Actively participated in RAC installation, administration and troubleshooting.
• Administered patching in a 3-node RAC environment.
• Conducted integrated capture and logical change record in Oracle Gloden Gate.
• Applied various processes in Oracle Gloden gate.
• Involved in installation, administration and patching of 12c OEM Oracle database environment.
• Deployed and supported Exadata.
• Checked parallelism instance parameter in Exadata.
• Participated in Exadata database migration.
• Participated in MySQL server administration.
• Worked in ASM storage devices mainly mirroring and striping.
• Worked in various financial modules like Oracle Assets, Oracle General Ledger, Oracle Payables, Oracle Receivables and Oracle Cash Management.
• Applied various PL/SQL scripts in Oracle database projects.
• Supported Oracle databases through multiple product lifecycle environments, from development to mission-critical production systems, for applications wif data warehouse and OLTP components.
• TEMPEffectively participated in EMS wif servers, databases and schemas, view, edit, search, group, sort and filter any data stored in a database.
• Set up USER access and Security Modal definition using APEX.
• Used database automation tools like SQL Server Integration Services (SSIS), PowerShell, BCP, TSQL, Chef, Puppet, and Docker.
• TEMPEffectively used Datavail dat halped to achieve DevOps environment by approaching hardware as disposable assets while ensuring dat data remains consistent and available.
• Experience in Amazon Web services wif CloudFormation, RDS, S3, and security and also in various number of automation including SSIS, PowerShell, and a host of third-party options.
• Participated Amazon RDS SQL Server and Oracle DB instances, which support Transparent Data Encryption
• TEMPEffectively used Amazon RDS, to manage database access through users, privileges, roles, and profiles, corporate security policy in teh database to protect against accidental or malicious destruction of data.

Environment: Oracle 12C RAC/11g RAC/9i, Red Hat Linux 4.x, Solaris 10, Sun v480, HP-UX11, AIX 5L, Windows NT/2000, TOAD 8.6, ASM, EMC, Oracle Enterprise Manager, Erwin 4.x, Visio, Warehouse builder, Data Guard, RAC, RMAN, TKPROF, SQL-Trace. Tomcat, Jenkins, Apache, Sonar, Ansible, Oracle 12c, Marathon, Ruby Chef, JIRA, Maven, Art factory, Ubuntu, CentOS, Linux, AWS RDS, AWS Cloud Watch, Google Cloud, Spock, Ruby, Chef-solo/server, python.

Confidential, Richmond, VA

Senior DBA

Responsibilities:

• Worked in teh group as a technical team lead providing support to development teams to create database objects, schemas, tables, indexes etc.
• Provided support to development teams to create database objects, schemas, tables, indexes etc.
• Administered Oracle Real Application (RAC) system and standalone database environment.
• Involved in checking CRS status in an oracle RAC environment in 11g and 10g environment.
• Check OCR and VD backup locations in an Oracle RAC environment regularly.
• Performed recovery from instance and media failures.
• Worked wif ETL - Informatica teams and developers to co-ordinate data loads, EIP releases & iterations from data warehouse database to OLTP databases.
• Performed capacity planning and space management.
• Extensively worked in teh performance tuning of teh programs, ETL Procedures and processes.
• Generated PL/SQL reporting and Unix Scripts to notify process failure/success.
• Developing and reviewing PL/SQL stored procedures.
• Created physical and standby databases in a Data Guard environment to use as reporting and an alternate failover database.
• Responsible for add and remove ASM disk group.
• Monitoring teh instances in a 3-node RAC cluster.
• Excellent noledge about Advanced Encryption Standard in Oracle Gloden Gate.
• Monitored checkpoints and various Gloden gate errors.
• Worked wif various files in Oracle Gloden gate like GLOBALS, ggserr.log, dirprm.
• Worked on various events in Exadata.
• Applied various shell scripts in oracle database projects.
• Experience in MySQL server database troubleshooting.
• Has assisted several project managers in reporting and activity management on a daily basis.
• Used Oracle Exadata for DBA activities and advanced queuing while replication.
• Performed cronjobs mostly backup jobs using crontab utility in Linux Operating System.
• Work closely more deep into 11g architecture viz. PGA, SGA and oracle logical structure as well as physical structure.
• Participated in Oracle EBS for higher-level business application.
• Monitored Oracle Glodengate replication and used logdump utility to read tracefiles.
• TEMPEffectively participated in EMS for creation and execution of SQL queries wif powerful SQL editor, handle multiple selected objects Confidential a time.
• Ad hoc issues and resolution was taken care of using APEX.

Environment: Oracle 12c RAC/11g RAC/9i, Red Hat Linux 4.x, Solaris 10, Sun v480, HP-UX11, AIX 5L, Windows NT/2000, TOAD 8.6, ASM, EMC, Gloden Gate, Oracle Enterprise Manager, Erwin 4.x, Visio, Warehouse builder, Data Guard, RAC, RMAN, TKPROF, SQL-Trace, JIRA, Maven, Art factory, Google Cloud, Spock, Ruby, JBoss, JRun, Tom Cat, IBM Web sphere.

Confidential, Milwaukee, WI

Senior Oracle DBA

Responsibilities:

• Installed Oracle Database 11gR2 wif Real Application Cluster (RAC) wif CRS and ASM in SOLARIS environment.
• Configured RAC Physical standby database for RAC primary using ASM filesystem in 11gR2.
• Worked on creation and deletion of RAC resources like listener/instance and database.
• Tuned databases for memory tuning by adjusting Buffer cache size, log switches and reducing check pointing, increasing sort area sizes, shared pool area, prioritizing oracle processes and increasing SGA overall in standalone as well as clustered environment.
• Hands on experience in troubleshooting RAC environment, using srvctl, crs stat and crs profile.
• Capacity Planning: Allocate system storage and plan future storage requirements.
• Monitoring and maintenance of multiple databases for production, development, testing.
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, monitor users, table spaces, memory structures, rollback segments, logs and alerts.
• 24 X 7 on call support of all production environments in group supported by our team.
• Utilized Various Raid levels such as mirroring and stripping wif parity.

Environment: Oracle 11g RAC/10g, Red Hat Linux 4.x, Solaris 10, Sun v480, HP-UX11, AIX 5L, Windows NT/2000, TOAD 8.6, ASM, EMC, Oracle Enterprise Manager, Erwin 4.x, Visio, Warehouse builder, Data Guard, RAC, RMAN, TKPROF, SQL-Trace, Apache, Sonar, Aurora- MySQL, Postgres, SQL Server, DB2, MS SQL Server Java, Eclipse.

Confidential, Hightstown, NJ

Senior Oracle DBA.

Responsibilities:

• Data migration between environments using Export/Import, expdp/impdp, Transportable Tablespace and Oracle Streams.
• Support Oracle databases for high transaction OLTP and Large Data Warehouse databases.
• Implemented Gloden Gate Technology on Oracle 11g/10g.
• Monitoring and maintenance of multiple databases for production, development, testing and Staging purposes using utilities like OEM and Toad.
• Worked on development of PL/SQL stored procedures, Triggers.
• Applying upgrade patches, maintenance and interim patches on all teh databases.
• Performance monitoring and tuning teh database using OEM, AWR and ADDM analysis.
• Has automated/monitored backup strategies for different databases.
• Administered Oracle Real Application cluster (RAC) system both 11gR2/10g.

Environment: Oracle10g RAC/9i, Red Hat Linux 4.x, Solaris 10TOAD 8.6, ASM, EMC, Oracle Enterprise Manager, Erwin 4.x, Visio, Warehouse builder, Data Guard, TKPROF, SQL-Trace, RMAN, Glodengate, TOAD, Sun Solaris, OracleSSO, OIM, Ruby, OBIEE, OEM, PL/SQL, Shell scripting, Perl, Python.