SUMMARY:

• Over 10+ years of experience as Oracle database administration in Linux& AIX environment
• Refreshoracle databases from production to Development and QA environments.
• Developed database monitoring/health check alert scripts for database uptime/downtime, backups, replication status, failed jobs, and free disk space using nagiosxi monitoring tool
• Experienced in Oracle installations, upgrades, patching, migration, configuring logical/physical architecture, database access and Security and auditing
• Performed backups and crash recoveries using conventional hot/cold backups and RMAN
• Experience in setting up replication using Dataguard and experience in using OEM, TOAD, Data Migrations using export/import and SQLLDR tools in oracle databases.
• Installed and Administered Oracle 11g standalone and Real Application Cluster (RAC) software with ASM and File systems.
• Developed database monitoring/health check alert scripts for database uptime/downtime, backups, replication status, failed jobs, and free disk space using nagiosxi monitoring tool
• Creation of database maintenance plans, rebuild/defrag indexes, integrity checks. Creation of TSQL scripts for full, differential, transaction log backups. Running scripts for optimizations, integrity checks on some instances that has special requirements beyond maintenance plans
• Planning and implementing disaster recovery procedures to ensure minimal downtime and data loss
• ITIL Skill set requirement (ProblemManagement / IncidentManagement / ChainManagement )
• Worked with various file transfer tools such as syncdat, rsync, ftp, sftp
• Experience in Production support DBA
• Created AWS EC2, RDS instances and worked on AWS lambda and S3 buckets
• Troubleshooting and configuring connection issues for ETL tools such as Informatica and Datastage
• Proficient with technology domains like User Management, Resource Accounting, Security and Network Management for various platforms like Microsoft Windows
• Capable of writing scripts with logical thinking and analyzing various methods to make the script run successfully and efficiently

TECHNICAL SKILLS:

Operating System: Windows 2000/2005/2008/2012/2012 R2, RHEL, IBM - AIX, HP-UX

Cloud Migration: AWS

Database: oracle 10g,11g,12c, SQL-Server 2006,2008,2012,2014,2016, mysql, mongo db

Languages: C, T-SQL, pythonprograming, windows powershell, perl, Go

Tools: /Utilities Double-Take, nagiosXI,rundeck, Jenkins, Toad, Jira, Servicenow, sql plus, rman, datapump

PROFESSIONAL EXPERIENCE:

Sr. Database Administrator

Confidential, California

Responsibilities:

• Provided application services support and database support for critical applications such as ONAIR and SALES
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management of all databases.
• Experienced in automating routine server tasks and alerts using various scripting technologies such as perl, Shell scripting, batch files, and python programming
• Installation, Configuration & Administration of Oracle 11gR2 standalone and RAC.
• Implementing 11g Data Active Guard for standalone physical databases and oracle RAC databases.
• Upgraded databases from oracle 10g to oracle 11gR2
• Troubleshoot the OS level Kernel parameter errors such as Ora-600 error using Ora-600 argument Lookup tool and Ora-7445 error.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN. Extensive usage of ADDM, AWR, ASSM, features of 10g/11gR2.
• Database structure changes, table/index sizing, SGA sizing, SQL, I/O and Application tuning, transaction monitoring, detecting lock contentions, tuning sort operations.
• Developing online RMAN backup scripts to automate backup procedures.
• Database Export/Import and evaluating the Backup and Recovery Procedures periodically & performing backups using RMAN. Restoration and recovery from backup as timely manner to support application development team for testing. Cloning of application from production environment to test environment using 11g new feature active database cloning and application of patches.
• Installed Oracle Enterprise Manager Cloud control 12c to monitor oracle databases in Production, development and QA Environment.
• Experienced in using TOAD and generate AWR reports to troubleshoot performance issues.
• Monitoring the table growth, database growth, current users, and system resource usage.
• Creating and maintaining table spaces, tables, indexes, users, roles, privileges and security.
• Sizing SGA, sizing db buffers, shared SQL area, log buffer based on requirements. Involved in team management, team building exercises for DBA team. Periodic Database Refresh/CLONING from production to Development & QA environments, maintaining Database Standards, Reviews, Documentation, Quality Assurance.
• Responsible in using GoldenGate to perform initial load between homogenous (oracle-to-oracle) as well as heterogeneous (oracle-to-sql server) environments.
• Responsible in configuring GoldenGate using User Exit and Voltage encryption to encrypt the data before being delivered into GoldenGate Trail file.
• Responsible in switching over/switching back to Physical standby database and vice-versa and starting GoldenGate processes accordingly.
• Worked with oracle Golden Gate to sync data across different platforms
• Install and configure sql server and sql server always on feature in sql server 2016
• Install and Configure HADR in DB2 environment
• Install and Configure database replicationsets in mongodb environment
• Created database-monitoring scripts to monitor oracle tablespaces, up/down status, alertlogs and rman backup jobs using perl and sql server up/down status, sql backup jobs using powershell from nagios to database servers.
• Worked with configuring and troubleshooting database connections to various ETL tools such as Informatica and datastage.
• Knowledge on creating jobs to run scripts in remote servers using Rundeck and Jenkins

Confidential

Graduate Research Assistant

Responsibilities:

• Installation, Configuration & Administration of Oracle databases
• Creating and configuring the Databases
• Creating logins and providing requested access
• Performing backups of databases by setting up backup schedules at regular intervals and also restoring databases when the client wants to require
• Creating and Monitoring the Maintenance plans - scheduling tasks to run daily and/or on weekends
• Shrinking the database when they reach threshold limit

Confidential

Project Associate

Responsibilities:

• Installation, Configuration & Administration of Oracle databases
• Creating and configuring the databases
• Create tables, indexes and stored procedures as per the application requirements
• Creating and Monitoring the Maintenance plans - scheduling tasks to run daily and/or on weekends
• Shrinking the database when they reach threshold limit

Confidential

Project Associate

Responsibilities:

• Creating and configuring databases
• Worked as 24 x 7 production support DBA in rotating on-call schedules
• Administrated User accounts by creating users, roles and privilege and managing those using grants and profiles.
• Created tables, views and other schema objects with appropriate table space sizes.
• Used HPSM for problem management, incident management, change management