PROFESSIONAL SUMMARY:

• Worked on HA of the databases including RAC, ASM and Data Guard.
• Worked extensively on all database administration tasks on 10g and 11g R2 DBs.
• 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 in a OLTP environment.
• Successfully upgraded production OLTP 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
• Extensive ETL experience using DTS/SSIS for data extraction, transformation and loading from OLTP systems to ODS and OLAP systems.
• Responsible for setting up Database Mail creating mail profiles, accounts 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.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Expert in implementing the snapshot isolation and DDL triggers.
• 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.
• 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.
• Designed Data Archival policy on high transactions tables using Bulk deletes, partition drops, exchange partition, Transportable Tablespaces.
• 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
• SQL Access Advisor, Performance Analyzer, Plan Manager, Automatic SQL Tuning, SQL performance analyzer, Table compression and SQL access advisor, SQL plan management and Database replay
• Table compression enhancement,
• Active Data Guard
• Mentors the team on technology concepts and ensures team compliance to best practices for design
• Worked on 12c Grid Control to setup central alerting system for monitor targets to be proactive to ensure high availability while getting the best performance.

TECHNICAL SKILLS:

Work History

Confidential

Oracle / SQL Production Support DBA

ROLES 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 unlocked user accounts, reset passwords.
• Ran scripts in Development and Production environments in SQL Server.
• Took backups of Development and Production environments in 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

Oracle / SQL DBA

Roles 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

• Oracle DBA
• Role Responsibilities:
• Managed Multiple clients
• Managed Clustered Databases
• Point in contact person for the clients I was managing
• Build RAC
• Designed ASM
• Build Data Guard
• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
• Configure ASM for Oracle 10G R1 installation with RAW devices, which include clustered file system for RAC.
• Conducting Installations of Oracle9i and Oracle 10g, Oracle 11g, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Solaris, Windows and Linux Servers
• Data modeling / Logical database design and implementation including index design
• Migration of system and applications from Oracle 9i to 10g, 10g to 11g using Database
• Configuring and using the Oracle Enterprise Manager in 10g for Performance, Maintenance and Administration tasks
• Create and maintain multiple databases.
• Create multiple 11g databases on RHEL5 in development.
• Schedule backup in 11g using db console.
• 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
• Using TCP/IP Protocol Configured SQL Net files on server / client machines, and resolved client connectivity issues.
• Constant monitoring of database space and space management
• Setting up Oracle Standby Data Guard.
• Setting up of Oracle and Application user accounts and passwords, monitoring application security
• Responsible to improve the performance by Using the Hints, Indexes, Explain Plan
• Performance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL Trace
• Worked with RAC implementation team. Added nodes.
• Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space
• Help developers writing database triggers, packages, procedures, functions, utilities for application development.
• Export and Import of User, Tables and Database using exp/imp and Data Pump.
• Designed database, tables and views structure for the new data mart.
• Created complex stored procedures and functions for integrity checks of transferred data.
• Helped provide end users with the ability to access and utilize the data stored in the data mart.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2000 using DTS Packages to MS SSQL server 2005.
• Involved in implementation and maintenance of disaster recovery solutions such SQL responsible for query optimization using MS SQL tools such as Query Analyzer, Profiler, and index tuning wizard.
• Implementation of Sql Logins, Roles and authentication modes as a part of Security policies
• Developed data access queries/programs using SQL Query to run in production on a regular a regular basis and assists end users with development of complex adhoc queries.
• Created maintenance plans for database Full, Differential and Transactional backup. Also scheduled for rebuild indexes, update statistic and check integrity.
• Implemented Constraints and Triggers for Data Consistency and to preserve Data integrity
• Migration of Access database to SQL Server Database, creating Triggers, stored procedures, tables and queries.
• Monitored database performance, processed speed activities on SQL profiler, and optimized database.
• I extensively worked on Transact-SQL DDL and DML .
• Proficient in creating Tables, Indexes, Joins, Triggers, Views, Stored Procedures, User Defined Data types and functions.

Environment: Oracle 10g RAC, Data Guard, ASM, SQL Plus, Oracle 9i, 10g, RHEL, AIX, Solaris

Confidential

Jr. DBA

• Written shell scripts
• Helped deployed SQL scripts during maintenance
• Refresh schemas
• Clone databases
• Managed database build sheets
• Created users
• Managed permissions
• Assisted Sr. DBAs
• Applied patches
• Worked on OEM
• Used Toad
• Helped troubleshoot network connectivity issues.

Confidential

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.