We provide IT Staff Augmentation Services!

Senior Oracle/ Sql Dba Resume

GA

SUMMARY:

  • 10.6 Years’ experience in project design, implementation, upgrades, Migrations, cloning , Oracle 12c/11g/10g RAC, 12c with ExaData, Goldengate, Administration Dataguard Security Admin in Production Servers, support, maintenance and administration, SQL Server 2012/2014,Cloud (Azure, AWS) Admin, Containers - Docker & Kubernetes.
  • I possess excellent written and verbal communication skills and have good team leadership skills and invariably meet client expectations. I'm working as an Oracle Team Lead, and have experience in implementation, Support and Maintenance, Migration and up gradation projects. implementation, Migration, Upgrade, IT Administration or IT Support projects & related task, Oracle 9i/10g/11g/12c Database Administration, Design and implementation and worked in 5 domains - Financial, Banking, Insurance, Retail and Healthcare different platforms like Windows, Unix /Linux (Ubuntu, IBM AIX, Sun Solaris, HP-UX).
  • Experienced in maintaining databases on large Production environments.
  • Expertise in installing, configuring and maintaining Standalone as well as RAC databases on various platforms and responsible for 24x7 availability of the database. .
  • Experience in Installation and administrations of Oracle 10g RAC, 11g RAC .
  • Implemented Dataguard and configured both the physical and logical standby database in the production environments.
  • Also responsible for well functioning of the database by Checking and Applying Patch set and Interim patches, Upgradations there by making the database software up-to-date. Upgraded databases from 8i to 9i, 9i to 10g and 10g to 11g, 12c
  • Proficient in using Recovery manager (RMAN), Flash-Back Technology, Automatic Storage Manager (ASM) & Automatic Database Diagnostic Manager (ADDM) .
  • Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage.
  • Developed database monitoring/health check alert scripts
  • Experience in using OEM/Grid Control
  • Planning and scheduling the Physical (Cold/Hot) backups, Logical backups and RMAN incremental backups.
  • Experience in taking Full and partial backups, Incremental and Cumulative backups using RMAN (Recovery Manager).
  • Experience in taking backup and performing recovery.
  • Experience in performing point in time recovery at times of necessity.
  • Created Clone databases in Dev and Test environments using RMAN cloning procedure as well as User manual cloning.
  • Implemented data transfer using Data Pump, Export/Import utilities.
  • Experience in Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analysing security problems.
  • Extensive Experience in writing Stored Procedures, Functions, Triggers and packages using PL/SQL.
  • Administration - Microsoft SQL server 2005/2008/2012 R2 databases, Install & support server for production and development server in cluster, replication.
  • Experienced in loading data from flat files into database tables using SQL*Loader,
  • Excellent communication skills, with strong troubleshooting, and problem solving ability.
  • Worked as a team member to provide 24x7 on call production database support.

TECHNICAL SKILLS:

Database: Oracle 12c/11g/10g, Oracle 9i, Oracle 11g RAC, MS-SQL DBA, 2012/2014

Operating Systems: Red Hat Enterprise Linux RHEL 4.x, 5.x, Sun Solaris 8,10, AIX 5.3,6.1,HP-UX 10.x,11.x, Windows NT/XP/2000/2003,HP-UX 10.x,11.x.

Technologies: OEM/Grid Control, Data pump Import/Export, GoldenGate, RMAN, ASM, SQL*Loader.

Tools: and Utilities: PL/SQL, SQL*Plus, SQL * Loader, Stored Procedures, Triggers, UNIX Shell Scripting, TKPROF, STATSPACK, AWR, Toad, VMware

PROFESSIONAL EXPERIENCE:

Confidential, GA

Senior Oracle/ SQL DBA

Responsibilities:

  • 24x7 production database and applications support
  • Installation, configuration and maintenance of Oracle 12c and 11g databases.
  • Extensive knowledge of Oracle OEM 12c Architecture, Framework, and Infrastructure
  • Expertise in Oracle OEM 12c implementation and operations in an enterprise scale
  • Experience with application deployment lifecycles, managing multiple OEM groups and templates
  • Knowledge in the architecture design of OEM and Oracle database and application monitoring
  • Experience with HA implementation of OEM
  • OEM 12c installation, upgrade, patching
  • Responsible for designing and building secure AWS EC2 instances based on Red Hat Linux with AWS expertise building custom AMI’s and infrastructure automation skills.
  • Implement, Migration & support to AWS Cloud
  • Experience with administration of Databases on AWS Cloud using EC2.
  • Demonstrate recent, professional exposure to support alternate RDBMS database flavors like MS SQLSERVER
  • Involved in construction of DR sites for all the Production databases.
  • Performed Database Refresh from Production to QA, UAT and Development databases.
  • Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.
  • Monitoring Day-Day Backups, Log’s.
  • Successfully implemented Backup & Recovery using RMAN, Conventional Hot and Cold backups.
  • Managing backup strategy for all production databases.
  • Taking the RMAN incremental (Differential & Cumulative) backups.
  • Backup/Restore scenarios using RMAN, HP Data-protector
  • Cloning of Databases from Production to Development and Test.
  • Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases.
  • Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
  • Implemented DRP (Disaster recovery plan) for critical databases.
  • Provided instance level performance monitoring and tuning for Wait Events, Sessions, Physical and Logical IO and Memory Usage.
  • Worked extensively on Performance tuning of Queries
  • Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, TKPROF, AWR and ADDM .
  • Experience with clusters, replication and log shipping, Install, configure and maintain SQL server databases
  • Understanding of Windows Server operation systems.
  • Advanced SQL query techniques in addition to experience with automating export/import tasks using DTS/SSIS.
  • Expertise with configuring, implementing and supporting high availability SQL Server.
  • Expert in Stored Procedures and SQL Coding.
  • Conducted time to time analysis and monitoring of the software and hardware requirements and act accordingly.

Environment: Oracle 9i/10gR2/12c RAC/11g R2 RAC, Red Hat LINUX, Windows 2008, MSSQL Server 2012/2005/2008, OEM/Grid Control, AWR/ADDM, RDBMS, SQL, PL/SQL.

Confidential, New Jersey

Oracle DBA/ Developer

Responsibilities:

  • 24x7 production database and applications support
  • Installed and Configured Oracle 10g RAC and 11g RAC databases
  • Upgraded Oracle databases from 9i to 10g and 10g to 11g version.
  • Maintenance of around 200 databases combined on all the production, development and testing environments.
  • Configured Oracle Standby Databases (Dataguard) for Oracle Disaster recovery.
  • Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases.
  • Restoration and Recovery of databases at the times of occurrence of critical failures.
  • Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
  • Implemented Oracle database backup & recovery solutions.
  • Extensive use of Oracle Data pumps Exp/Imports utility for moving data among the servers.
  • Performed large batch jobs, and tuning of SQL queries and database systems.
  • Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
  • Configured and implemented Oracle Streams.
  • Performed Schema as well as Table level Replication using Oracle Streams.
  • Implemented downstream capture at the destination database using Oracle Streams.
  • Responsible in configuring and backing up database using Hot backups, Cold backups, Logical backups and RMAN incremental backups
  • Performed automated backups and scheduling using scripting.
  • Responsible for migration of databases.
  • Written PL/SQL functions, stored procedures, packages and triggers
  • Worked with Data pump to take the logical backups of databases.
  • Experienced in performing Point in time recovery.
  • Used Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
  • Tested database performance issues (monitoring and tuning) to ensure database optimization.
  • Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
  • Involved in gathering requirements from end users.
  • Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
  • Estimate growth of database size by detail analysis of the company’s future policies and generating reports for the management to act in advance.

Environment: Oracle 11g/10g, Oracle 11g RAC, Oracle 10g RAC, Dataguard, RedHat Linux, HP-UX, Sun Solaris, IBM AIX, Windows, TOAD, Grid Control, ERWIN, SQL, PL/SQL

Confidential, Houston

Oracle/ SQL DBA

Responsibilities:

  • 24*7 Production Database Administration Support
  • Installation, configuration and support of Oracle 11g RAC and Standby Databases (Active Data Guard) for High Availability and Disaster Recovery.
  • Performed security and capacity design and planning.Upgraded databases from Oracle 9i to 10g, Oracle 10g to 11g.
  • Performance monitoring and tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM.
  • Involved in construction of DR sites for all the Production environments.
  • Performed Database Refresh from Production to QA, UAT and Development databases.
  • Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space.
  • Provided instance level performance monitoring and tuning, Event Waits, Sessions, Physical and Logical IO and Memory Usage.
  • Backup and recovery, Cold backups, hot backups, Logical backups, RMAN backups (Full, Incremental Backups, Differential, Cumulative Backups).
  • Implemented Standby Databases with high availability and performance configurations and participated in Switchover and Fail over tests
  • SQL Server Database Administrator
  • Experience working with SQL server 2012/2008/2005.
  • Experience with clusters, replication and log shipping, Install, configure and maintain SQL server databases
  • Understanding of Windows Server operation systemsDatabase cloning for development, testing from production
  • Responsible for capacity planning, database security, recovery planning and installing patches
  • Writing Stored Procedure, Functions, Trigger and packages using PL/SQL.
  • Installed and configured Golden Gate
  • Partitioned large tables for better performance and manageability
  • Migrating databases from Windows to Linux, Sun Solaris to IBM AIX.
  • Experience in Logical Database Design, Physical Database designAcc

Environment: Oracle 11g RAC/10g RAC/Oracle 9i, Data Guard, Sun Solaris, IBM AIX, HP-UX, Red hat Linux, RMAN, ASM, SQL*Loader, Data Pump, Golden Gate, TOAD, OEM/Grid Control, SQL, PL/SQL, TKPROFEXPLAIN PLAN, AWR

Confidential, Cincinnati, OH

Oracle DBA

Responsibilities:

  • Installed and configured Oracle 8i, 9i, 10g.
  • Performed Database Upgradations from 7.3, 8i to 9i, 9i to 10g.
  • Responsible in applying the patches from time to time to make the database software up-to-date.
  • Involved in analysis of market risk and claims data.
  • Creation of new Tablespaces, adding and modifying data files in order to resolve Disk Contention Issues.
  • Performing backups and recoveries.
  • Designed and implemented appropriate backup and recovery procedures to meet the business requirements.
  • Responsible for automatic backups for performing hot backups on a daily basis and cold backups on a monthly basis.
  • Maintained control files, log file, data files, table spaces and rollback segments.
  • Creation of database users, granting/revoking the privileges
  • Tuning, troubleshooting, monitoring and optimizing database performance.
  • Worked closely with senior DBA to understand the business and technical requirements.
  • Designed database tables, implementing referential integrity.
  • Developed triggers which internally called procedures and functions.
  • Performed complex SQL query tuning, index reorganization.
  • Involved in all phases of the software development life cycle.
  • Designed and developed various UNIX Shell, PL/SQL and SQL scripts
  • Involved in documenting the entire system architecture and data flow.

Environment: Oracle 10g/9i/8i/7.3 RedHat Linux, Sun Solaris, HP-UX, SQL, PL/SQL,Sun Solaris 5.8/5.9/5.10, Oracle RDBMS 9i (9.0.2)/10G(10.2.0.2), 9iAS & 10gAS, OEM, OAM, RMAN, ASM, Data Pump, Data Guard.

Confidential, Virginia

Oracle DBA/ Developer

Responsibilities:

  • Installation and configuration of Oracle 9i, 10g software
  • Installed and configured Oracle 10g RAC
  • Upgraded databases from 8i to 9i, 8i, 9i to 10g. Applied CPU and PSU patches
  • Adjusted data models when necessary under direction of data architects.
  • Implemented Oracle Dataguard in order to achieve the high availability of the database by maintaining the Standby database.
  • Used Recovery Manager (RMAN) and Created recovery catalog on separate server.
  • Responsible for backups and recoveries
  • Assured Daily Backups and Archiving were done accurately and consistently.
  • Implemented and maintained Database security.
  • Created / Altered / Dropped Users as and when required and administer their respective quotas and profiles.
  • Cloned the database using RMAN to migrate data from PROD to UAT/QA/SIT and Dev databases.
  • Implemented shell scripts for backup and recovery
  • Restoration of dropped tables using Flashback technology.
  • Created Database Links and Snapshots (Materialized views).
  • Performed Hot Backups and maintained database availability to support non-stop Business operations.
  • Developed UNIX shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
  • Optimized SQL, PL/SQL code and performance tuning using AWR, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM
  • Knowledge in Data warehousing and implementation and supported as Oracle Database administrator in Data warehouse projects.
  • As a member of the analyzing and designing team, the responsibilities were to understand the application requirements and build up system specifications.
  • Writing PL/SQL stored procedures and functions for data operations team and suggesting developers to write proper query to get optimal performance.

Environment: Oracle 10g/9i/8i, Oracle 10g RAC, Dataguard, RedHat Linux, Sun Solaris, TOAD, Grid Control, ERWIN, SQL, PL/SQL.,SQL*LOADER

Hire Now