SUMMARY

• Around 17 years of experience as an Oracle Database Administrator providing 24/7 support for production 11g/10g/9i/8i/7.x databases on various platforms of operating systems such as Red Hat Linux, Sun Solaris, HP UX and IBM - AIX.
• Formal training in Oracle Database Administration 9i, 10g and 11g and education in Master in Computer Applications.
• Experience installing, patching and upgrading of Oracle software 9i, 10g and 11g on Unix, Linux and Windows environment.
• Experience installing Oracle Real Application Clusters (RAC) databases on Linux and Sun Solaris operating system.
• Strong experience configuring, administration, maintenance & recovery of single-instance & Real Application Clusters (RAC) Databases.
• Strong experience configuring data guard environments for disaster recovery and high availability, experience setting up physical & logical standby, active data guard.
• Experience using Oracle utilities DataPump, SQL Loader, RMAN, Original export/import for database administration and maintenance.
• Extensive experience planning and execution of Database Backup and Recovery using RMAN tool.
• Strong knowledge of SQL, PL/SQL and Shell scripting for database administration and maintenance.
• Performance tuning experience with OEM, STATSPACK/AWR/ADDM.
• Strong experience user and database security management.
• Experience cloning databases for development/testing environments using traditional backup methods as well as using RMAN tool.
• Strong knowledge of Oracle database best practices for administration, high availability, disaster recovery and performance tuning.
• Strong knowledge of Systems Development Life Cycle (SDLC).
• Understanding of change management principles associated with new technology implementations.
• Working knowledge Golden Gate replications.
• Well versed with Oracle security features like data masking, redaction, audit vault and database firewall.
• Domain knowledge in Telecom Billing & Mediation, Order Management System, Balance Manager, Core Banking and Foreign Exchange operations
• Good understanding of Bigdata Administration and Other dbs like PostgreSQL and Maria db.

TECHNICAL SKILLS

OS: HP-UX, Tru 64 Unix, IBM AIX, Sun Solaris, Red Hat Linux, Oracle Enterprise Linux 6.X, 7.X, and Windows 2003

Languages: SQL and PL/SQL, UNIX Shell, SED/AWK and Perl Scripts, HTML with CSS

Databases (RDBMS): Oracle 9.x, 10.x, 11.x, 12.x. Microsoft SQL Server 2005

NoSQL: MongoDB 3.4, 3.3,Maria DB 10.1.20, Postgresql (EnterpriseDB 9.5.4.9)

Schedulers: Crontab, Oracle Scheduler, OEM, Windows Task Scheduler

Clusters: Oracle Clusterware and OCFS

High Availability: Oracle 10g/11i, 12c RAC, Standby Database, Clustering and Data Guard Setup, Automatic Storage Management

Replication: Quest Shareplex Replication Queue, Oracle Transactional Replication with Golden Gate Replicator, Oracle Streams

Tools: & Utilities: Toad, SQL Navigator

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

Lead Oracle DBA

Responsibilities:

• Design solution for enterprise service bus project for client.
• Performance analysis using AWR, OEM Grid and tkprof etc Oracle Databases.
• Conducted backup/recovery through RMAN or Export & Import.
• Implemented the database access security through triggers. Created triggers for job modifications.
• Applying Project management knowledge and skills to production and other environments.
• Database support specialist on many project conference calls.
• Oracle 11g, 10g, Maria DB & PostgresSQL installation and administration.
• Create migration plan and work with different teams for migration of databases.
• Oracle Performance tuning expert for 10g and 11g databases.
• DB Support specialist for ONCALL, night and weekend projects
• Perform database analysis, design, coding, testing and implementation of database structures.
• Work with Dev and architecture team to create database design documents.
• Capacity planning, monitoring and management.
• Manage day-to-day administration on production databases.
• Monitor cpu, memory, disk i/o, paging, swapping using various Unix commands.
• Use Oracle’s Enterprise Manager (OEM), AWR, ASH reports for database maintenance and performance tuning.
• Prepare and maintain project plans and track activities against the plan, providing regular and accurate reports to customers and line management as appropriate.
• Raise SR against Oracle to resolve issues.
• Configuration and management of standby databases using Data-Guard and perform Failover tests for high availability.
• Code and edit shell scripts to automate schedules for database administration and monitoring.
• Manage user management for database security.
• Applied data masking and redaction technology to protect data.
• Resolve end users’ issues with providing 24x7 supports for designated production databases. Ensure data availability as per the service level agreement.
• Design develop and implementing process improvements within the database environment.
• Provided recommendations for data synchronization between applications.
• Working on Maria db & EDB Postgres migration tasks.
• Install, maintain and Troubleshoot Golden Gate.
• Provided assistance for integration of auditing and alert systems in NoSQL databases.
• For NoSQL databases, designed storage infrastructure systems and configured database performance systems.
• Created comprehensive health check report across all production env. in shell and PowerShell and scheduled it.

Environment: Oracle 11g, 10g, Toad, Data-guard, Golden Gate, RMAN, Remedy, WinScp, SQL*Loader, Windows 2003, RHEL 5.x, ERWIN,EDB Postgre SQL & Maria db.

Confidential, Richardson, TX

Lead Oracle DBA

Responsibilities:

• Applying Project management knowledge and skills to production and Oracle data warehouse projects.
• Oracle database support specialist on many project conference calls.
• Writing Project Management Delivery documents such as Project management ROADMAP, database cloning techniques, Oracle 11gR2 installation step by step, PM issues, risks, and lessons learned.Oracle 11g, 10g, 9i installation and administration.
• Oracle Performance tuning expert for oracle 9i, 10g and 11g databases.
• Oracle Support specialist for ONCALL, night and weekend projects
• Installation/Configuration/Compliance documentation of Oracle Enterprise Manager 12c cloud control on 11.2 databases on Unix/Linux
• Suggested and implemented Oracle Best Practice for Red Hat Linux 7 systems for Oracle Performance
• Suggested and implemented faster backups with RMAN and incremental backups.
• Create and maintain solutions for database software installation, Patching and database creation.
• Capacity planning, monitoring and management.
• Perform transaction-sizing measurements.
• Supporting Oracle Spatial like loading data, indexing and performance tuning.
• Install and upgrade oracle spatial feature.
• Manage day-to-day administration on production databases.
• Monitor cpu, memory, disk i/o, paging, swapping using various Unix commands.
• Work with architecture team for server and database configuration.
• Use Oracle’s Enterprise Manager (OEM), Statspack Reports, Explain Plan, SQL Trace and TKPROF for database maintenance and performance tuning.
• Prepare and maintain project plans and track activities against the plan, providing regular and accurate reports to customers and line management as appropriate.
• Raise SR against Oracle to resolve issues.
• Configuration and management of standby databases using Data-Guard and perform Failover tests for high availability.
• Design, create and maintain design documents for the database changes.
• Code and edit shell scripts to automate schedules for database administration and monitoring.
• Manage user management for database security.
• Applied data masking and redaction technology to protect data.
• Resolve end users’ issues with providing 24x7 supports for designated production databases. Ensure data availability as per the service level agreement.
• Design develop and implementing process improvements within the database environment. Attend organizing meetings to sort out Capacity planning, Database performance and reliability and Change management issues.
• Provided recommendations for data synchronization between applications.
• Working on Maria db migration tasks.

Environment: Oracle 11g, 10g, Toad, Data-guard, ERWIN,RMAN, Remedy, WinScp, SQL*Loader, Windows 2003, RHEL 5.x.Oracle Spatial

Confidential, Richardson, TX

Lead Oracle DBA

Responsibilities:

• Lead the Planning migrations and upgrades of Oracle Databases to target data centers using backup/restore, exp/imp, SQL Loader, log shipping, TTS etc. and DB/Storage migration tools.
• Installation and patching of Oracle database products and components, creating databases, tablespaces, users etc.
• Tuning target database environments for better performance and availability.
• Coordinate and assign the task to offshore as per release to release basis and day to day basis.
• Using Tiger (Amdocs) apply patches and upgrade the systems.
• Production support for Enabler, ACS and OMS systems.
• Create test data from production after masking the sensitive data.
• Work closely with developers to tune SQL queries.
• Performing logical backups using Datapump utility
• Developed SQL and shell scripts for database monitoring.
• Schema management, space management as per the requirements of team.
• Assigning appropriate privileges through the use of roles.
• Monitoring object usage & allocating space as per requirement.
• Creating tables and views and supporting developers.
• Implementing a backup policy with incremental backups.
• Sizing database objects for effective space management and optimal performance.
• SGA tuning including tuning the shared pool, database buffers and redo buffers.
• Using shell scripts and SQL scripts to schedule backups.
• Utilizing Enterprise manager to monitor alerts, schedule jobs, monitor SQL loads, generate AWR reports
• Cloning production databases for development, test environment with RMAN Duplicate feature.

Environment: Oracle 9i, 10g, Sun Solaris, Windows 2003, SQL developer, Datapump, Remedy.

Confidential, MiddleTown, NJ

Oracle DBA

Responsibilities:

• Oracle 10g, 9i installation,upgradation and Configuration.
• Apply Patches to existing versions.
• Collect database performance statistics from production databases for trend analysis.
• Hot Backups & Exports, Restores & Refreshes for regression tests.
• Development support, Coding standards, application & database tuning.
• Preventive Maintenance & re-orgs.
• Ensuring successful & periodical Backup, Restoration & Tuning.
• Develop, Implement and administer database policies and procedures
• Using Statspack for analyzing database performance and tuning with ADDM suggestions.
• Recommend changes to increase efficiency, minimize operating expense or improve accuracy and timeliness of application systems.
• Perform database analysis, design, coding, testing and implementation of database structures.
• Finest granularity approach to Oracle implementation and defragmentation.
• Capacity planning, capacity monitoring and management.
• Perform transaction-sizing measurements.
• Managed day-to-day production databases.
• Monitoring CPU, memory, disk I/O, paging, and swapping using various UNIX commands.
• Analyze disk space requirements.
• Oracle’s Enterprise Manager (OEM), Statspack Reports, Explain Plan, SQL Trace and TKPROF.

Environment: Oracle 10g, 9i, Toad, RMAN, Remedy, WinScp, SQL*Loader, Windows 2003, Solaris5.x

Confidential

Oracle DBA

Responsibilities:

• Installed 9i, 10g, database on Windows 2000 and SUN SOLARIS.
• Wrote control files for SQL * loader to load data into data warehouse.
• Provided database related services to their development and QA environments.
• Was actively involved in constant site enhancements along with developers - code and data push between different servers and testing and moving to production.
• Logical and Physical backup procedures.
• Data exports from production and staging databases.
• Tuned SQL queries to pull data from data warehouse tables.
• Tuned production database performances and was instrumental in SQL tuning that improved application response.
• Run oracle stats pack to tune the databases.
• Wrote SQL scripts for DB monitoring, and online backups.
• Implemented database related security measures that proved very effective.
• Implemented Oracle Replication to enable database fail over in case of system or database crash.
• Backup and recovery using cold, hot and export methods.
• Wrote database triggers, functions and procedure by using PL/SQL.
• Automated a no. of database related jobs.
• Set multiple destinations for archives redo logs for safety.

Environment: Oracle 9i/10g, SQL, PL/SQL, Toad, Windows 2000 and SUN Solaris