SUMMARY

• Worked on HA of the databases including RAC, ASM and Data Guard.
• Build Data Guard
• Build Multiple node RAC Cluster
• Worked on Silent Installs.
• Worked extensively on all database administration tasks on 10g and 11g R2 databases.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Worked as a lead in Data Center Consolidation on large database systems.
• Worked as a primary support for database related issues with clients.
• Worked on multiple projects in parallel to daily DBA activities.
• Implemented Disaster Recover Site with Data Guard, and maintained Physical and Logical Standby Databases along with Active Data Guard and Oracle GoldenGate.
• Performed Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.
• Used tools like TOAD, DB Console, Confio, and Grid Control to monitor database performance.
• Build and administer SQL Server 2005/2008 standalone and cluster databases.
• Evaluated Oracle features and Oracle related products to leverage existing hardware/software/incenses.
• Build, configured and managed 9i/10g/11gdatabases.
• 11g R2 Administration included:
• Installation of RHEL5, set up group/users, installing Linux packages and setting kernel parameters
• Upgrade from 10g R2 to 11g R2
• Build 11g R2 RAC from scratch including Linux OS installation.
• Installed11g R2, upgraded and performed Hot Patching
• Partitioning - system partition, virtual column base partition, reference partition, composite partition and range-range partition
• New features and enhancements of RMAN, Flashback and logminer
• Data recovery advisors
• Worked on SQL Access Advisor, Performance Analyzer, Plan Manager, Automatic SQL Tuning, SQL performance analyzer, SQL access advisor, SQL plan management
• Build Active Data Guard
• Worked on 12c Grid Control to monitor databases.
• Possess experience in SQL Server Database Administration.
• Worked with databases ranging from a few GB to up to 3 TB.
• Developed, maintained, and administered SQL Server 2008 and 2012 databases
• Successfully upgraded production database server from SQL Server 2005 to SQL Server 2008.
• Worked on SQL Server 2008 R2 to 2012 Migration process.
• Created documentation to install SQL Server 2008 and SQL Server 2012 & developed SQL Server Maintenance Plans
• Responsible for setting up Database Mail using SQL Server Agent Mail.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005.
• Monitoring SQL server performance using SQL Profiler to find performance and dread locks.
• Expertise in T-SQL writing stored procedures, triggers and functions.
• Provide 24/7 on call support

TECHNICAL SKILLS

Operating Systems: RHEL, HPUX, AIX, Sun and Windows

RDBMS: Oracle 12c, 11/10g, 9i, SQL Server

High Availability: RAC, Data Guard, ASM

Languages: SQL, PL/SQL, UNIX Shell scripting, T-SQL

Tools: RMAN, OEM, sqlldr, exp, imp, expdp, impdp, TOAD, dbconsole, asmcmd

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, SQL Advisor, performance analyzer

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

SQL / Oracle DBA

RESPONSIBILITIES:

• Set up Oracle 11g Data Guard.
• Migrate databases from one data center to another.
• Oracle DBA duties involving development and production support such as installations, configurations, backup/restore & recovery, database monitoring & operating system configurations, database performance tuning, assisting in the logical/physical database design, applications profiling, tuning queries and providing support to developers.
• Performing Hot/Cold backups of the database through RMAN or User Managed method.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Review alert logs and dump files to check for any problems related to the database.
• Perform database cloning/exp/imp to setup identical databases in the production and development environments.
• Database Backup, Database Restore and Database Recovery using various tools.
• Database Reorganizations for better space management.
• Performed Database Refreshes and Database Copies for Development, Test and Production
• Monitoring frees space in tablespaces, Archive log destination, Database/Listener availability,
• Blocking Locks monitoring etc.
• Worked with SQL Server 2008 and 2012.

Confidential, Indianapolis, IN

Oracle / SQL Production Support DBA

RESPONSIBILITIES:

• Supported multiple database farms including development/production sizes up to 5 TB for 24/7.
• Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.
• Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.
• Ensure databases adhere to corporate standards and policies. Worked with application team, developers, change management team and DBA team to ensure smooth life cycle progress from development through testing and production implementation.
• Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
• Created new users, granted database access permissions, revoked permissions, locked and unlockeduser accounts, reset passwords.
• Ran scripts in Development and Productionenvironments in SQL Server.
• Took backups of Developmentand Productionenvironmentsin SQL Server
• Performed database refreshes in SQL Server.
• Migrated SQL server 20008 to SQL Server 2008R2/2012 in Microsoft Windows Server 2008R2/2012 Enterprise Edition.
• Design & implementation of single product application feature module /sub-system.
• Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2008R2/2012 Enterprise Edition on SAN environment.
• Experience in coding, unit testing and integration testing for functionality
• Migrated SSIS packages from SQL Server 20008 to SSIS 2008R2/2012 product design, systems analysis and development activities on application software upgrading SQL Server from version 20005 to 20008
• Applying patches and service packs to keep the database at current patch level.
• Deployed packages to production systems for data migration.
• Created Synonyms.
• Worked on RAC databases.
• Updated Export jobs by changing RMAN retention policy.
• Setup process to purge files older than x days and setup notification to dba's.
• Automated Import process by writing scripts.
• Cloned databases using RMAN
• Cloned SQL Server databases
• Refresh schemas using export import and Data Pump
• Used 12c Grid Control.
• Was part of 24/7 team.

Confidential, Fort Worth, TX

Oracle DBA

Responsibilities:

• Build RAC from scratch including OS and RAID configuration.
• Worked on VMWare
• Used RMAN for backup/restores
• Cloned databases from RMAN duplicate database.
• Setup and documented Oracle GoldenGate replication on 11g for support team.
• Database refreshes using export /import and datapump. Used RDA, ADDM and AWR reports to monitor the database performance.
• Used power designer, E/R Studio for data modeling and to estimate the database size, database design reviews.
• Developed and maintained PL/SQL Stored Procedures, Packages, Functions and Database Triggers. Developed and maintained shell/Perl scripts for setting up batch jobs and managing release scripts.
• Implemented SQL outline to get the better execution plan for the offending queries. Setting up analyzing scripts and coordinated with development team to gather table statistics.
• Perform Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.
• Day to Day General Administration Tablespace Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles.
• Diagnosed Oracle bugs and coordinating with Oracle support through metalink to resolve them in timely manner.
• Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.
• Primary DBA for 1GB - 2.5TB database for 24/7 support.
• Upgrade Data warehouse Database from 8K block size to 32K block size to optimize performance.
• Refreshed multiple databases for Development and Testing upon short request.
• Served as part of a 7 member DBA team which was involved in the maintenance of the Oracle 9i/10g database for the Production as well as the development environments.
• Actively involved in designing/Testing of Disaster Crash recovery.
• Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g.
• Performance Monitoring and Tuning of Oracle Application Servers using Statspack, TKPROF, and OEM for tuning on 9i and on 10g using SQL access manager, SQL tuning manager.
• Performed database cloning/exp/imp to setup identical databases in the production and development environments.
• Created and maintain users, roles and privileges.
• Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
• Perform Backup and Recovery thru RMAN.
• Strong exposure in Installing / configuring / maintaining RAC, Dataguard, Physical / Logical Standby environments.
• Provided technical troubleshooting and give consultation to development teams.
• Performed Database Refreshes and Database Copies for Development, Test and Production databases.
• Implemented basic replication through Materialized Views.
• Involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
• Initiated cronjobs to review alert logs and dump files to check for any ORA- errors.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Performed Database Administration using TOAD, Oracle Enterprise Manager and SQL scripts.
• Installing SQL Server with minimum access privileges service account to improve security and to attain high ratings in SOC audits
• Installed, configured SQL Server 2005 Clustering on Microsoft Clustering services (MSCS) from Hardware inventory to test environment.
• Involved in Analyzing and Upgrading SQL Server 2008 test servers to SQL Server 2005.
• Having experience on SAN and RAID levels and building SQL Cluster servers on SAN Environments.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Designed and implemented comprehensive Backup plan using SQL Nightspeed.
• Resolved and tweaked memory pressures caused during product release.
• Worked with customers on Application rollouts and server migrations.
• Troubleshoot performance problems and fine-tuning of databases.
• Expertise in designing databases and capacity planning.
• Rebuilding the indexes at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• To provide 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.

Environment: PL/SQL, SQL, SQL*Plus, Oracle 8i,9i, 10g, 11g; RHEL, AIX, Windows NT/2000, HP UX,TOAD, Grid Control, GoldenGate, OEM, SQL Developer

Confidential, IL

Oracle DBA

Responsibilities:

• Worked as a Jr. DBA
• Written shell scripts
• Helped deployed sql scripts during maintenance
• Refresh schemas
• Clone databases
• Managed database buildsheets
• Created users
• Managed permissions
• Assisted Sr. DBAs
• Applied patches
• Worked on OEM
• Used Toad
• Helped troubleshoot network connectivity issues.
• Installation of SQL server 2000, 2005, 2008
• Applying the service packs and the hot fixes
• Backup and restore of the DB's.
• Implementation and troubleshooting failover clustering for SQL Server.
• Trouble shooting the performance issue at server level.
• Creation and trouble shooting of Log shipping.
• Creation and trouble shooting of mirroring.
• Creation and maintenance of replication.
• Managing security through logins, users, and roles.
• Creation and troubleshooting of Jobs.