SUMMARY:

• 10 years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008 and 2005.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
• Expertise in T - SQL writing stored procedures, triggers and functions.
• Administering SQL Server High Availability and Disaster Recovery strategies using sql replication
• Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.
• Experience in using DMV and dynamic management functions for performance trouble shooting.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Experience in Disaster Recovery Planning and Security Management operations.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis, statistics analysis
• Worked on SQL Server 2012 migration from SQL Server 2008 / 2005.
• Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Having Experience on Data center servers and handling large database upto 2 TB databases.
• Handling Memory configurations for SQL Server 2012 on Windows 2012.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also package for data transfer between the two environments.
• Working knowledge in Analysis Services(SSAS), Reporting Services(SSRS).
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Strong experience in mentoring team members and writing documentation.
• 24 X 7 Production Database on Call Support
• Implemented transactional Replications and log shipping
• Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK.
• Experience with Oracle 12c/11g/10gRAC/9i/8i in Installation, Administration, Monitoring, Database Backup and Recovery.
• Extensive Experience working with Business users determining data/requirements needs and Data Modelling.
• Extensive experience in Database Administration activities such as installation, patching, upgrading, migration, backup & recovery, performance tuning and capacity planning.
• Strong experience working in large scale enterprise environment containing OLTP and OLAP systems encompassing many terabytes of data.
• Design, test, implement, maintain, and control the companies physical, relational, and object-oriented databases like Oracle 11g, 10g, 9i, 8i across multiple platforms like HP UNIX, Red hat LINUX, IBM AIX, Sun Solaris, Windows including performance tuning and trouble shooting of the databases.
• Extensive experienced in using Oracle Utilities & functions including RMAN Catalog, Data Guard, AWR, ASH, Stats pack, Data Pump, exp/imp, OEM grid controls.
• Experience in Real Application Clusters RAC and Standby database.
• Hand on experience in Backup, Recovery and Restoring of databases using RMAN catalog.
• Installation, Configuration of Oracle Data Guard for Physical and Logical mode.
• Experience in Performance Tuning for 10g and 11g (I/O, Memory & SQL Tuning). Utilities used include AWR, ASH, ADDM, STATSPACK, TKPROF and Sizing of tables, indexes etc.

TECHNICAL SKILLS:

Databases: MS SQL Server 2012, 2008, MS SQL Server 2005, Oracle 12c/11g/10g/9i/11g RAC,MYSQL

DBA: database administration of MS SQL Server 2012,2008, 2005,MYSQL

Operating System: Windows 2008 R2/2003/2012 R2 advanced Server, NT & Windows 9x, Linux

Tools: Backup Utility, SQL LiteSpeed,IDERA, RAC, OEM Grid Control SQL Navigator, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, TOAD, Patch Management, SQLNET, ETL, ODBC, Oracle Streams, Golden Gate, Data pump, Data Guard, VERITAS Net Backup, Vmware,Service Manager 9,BMC remedy, Service Desk 4.5

PROFESSIONAL EXPERIENCE:

Confidential, West Borough, MA

SQLSERVER DBA/ORACLE DBA

• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Installed and administered 2 Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Expert in Using DMVs, Performance dash board, database snapshots and tracking Performance Counters.
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA),Perfmon
• Experience in using third party tool Idera
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Implemented Data partitioning, Common Table Expression (CTE).
• Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers).
• Experience in backups and recovery using RMAN and Scripts.
• Maintained a Catalog server and involved in backup of Catalog database.
• Scheduled Oracle Jobs and Backups using CRONTAB.
• Experience in Online and Offline backups and recovery.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Performed Block Recovery and Data file recovery using RMAN.
• Involved in Database Security and Auditing to protect databases potentially including the data, the database applications or stored functions, the database systems, the database servers and the associated network links against compromises of their confidentiality, integrity and availability.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Performed data refresh at Schema level using EXPDP.
• Daily Health Check Up of the Database and SQL Queries using AWR, ADDM and TKPROF.
• Tuned the performance of the SQL’s using TKPROF and STATSPACK reports.
• Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Query optimizing using CBO (Cost Based Optimization) and RBO (Rule Based Optimization)
• Performance Tuning for the SQL queries which are Running slow and taking more CPU cost
• Involvement in day-to-day activities like Space management, rectification of Lock problems, managed quotas, Table partitioning to improve I/O access.
• Alert log Monitoring for critical databases every day in the production environment.

Environment: SQL Server 2008/2012 Enterprise, Windows Enterprise Server 2012 R2, NET, SFTP, Microsoft Reporting Services, Oracle 11g/10g, HP-UX 7.x/11.x, RHEL 5.x, ASM, OEM, RAC 11gR2, RMAN and Data Guard, Explain Plan, SQL Developer, PL/SQL Tuning, Data Pump Putty

Confidential

SQLSERVER /ORACLE DBA/MYSQL DBA

Responsibilities:

• Database Administrator, Database Programming.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Deploying new code base release to UAT and Production Environments.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Working with customers on Application rollouts and server migrations.
• Extensively worked on Enterprise Manager for managing the database.
• Troubleshoot performance problems and fine-tuning of databases.
• Involved in Index Analysis and Performance Tuning.
• Worked with different upstream team for downloading ETL MART data.
• Converting DTS packages into SQL Server 2005 Integration Services.
• Migrating SQL Server 2000 data bases into SQL Server 2005.
• Recovering the databases from backup in disasters.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Installation, configuration, maintenance and tuning of Oracle 10g 11g on RHEL 5.0, 5.5, 5.7 &IBM-AIX 6.1.
• Experience in Oracle server administration. Created Users, Implementing Backups, Cloned the Databases, Backing up and Refreshing ORACLE DB’s.
• Performance tuning and diagnosing DBMS and individual Production databases
• Creating users with restricted access, with default and temporary table spaces. Partitions on tables and indexes. Creating roles and granting to users based on their group requirements.
• SQL issues and Tuning Considerations for Different Applications.
• Influencing Skills, High confidence, Passion for retail, Empathy for people, Strategic thinking
• Performed performance tuning using Explain Plan, SQL*Trace, TKPROF, Statspack, ASH and Unix commands.
• Tuning which involved I/O, Memory, CPU utilization, SQL Tuning, SGA Tuning, Shared Pool Tuning, Buffers and Disk I/O tuning.
• Experience in Very Large Multi Terabyte Database (VLDB) and also performed migrations in this environment.
• Documented all Oracle database installations and database operations
• Responsible to provide 24 x 7 database administrative activities over different database servers.
• Created databases in RAC environment and involved in moving databases from TEST to Production Environment.
• Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment (11GR2).
• Maintaining ASM in RAC environment.
• Configured Physical Standby for Production databases and converted Physical standby to Snapshot Standby and ACTIVE data-guard.
• Maintained DR server and troubleshooting issues in DATAGUARD environment.
• Applied patching on 10g from 10.2.0.1 to 10.2.0.x.
• Involved in Up-gradation of HP- UNIX databases from 10.2.0.x to 11.2.0.x.(11gR2)
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for Migrating Oracle 10gR2 to the latest Oracle 11gR2 and applied patches as required.
• Export and Import of database objects using EXPDP and IMPDP.
• Cloned schemas, objects and data on new server using Datapump.
• Experience in backups and recovery using RMAN and Scripts.
• Maintained a Catalog server and involved in backup of Catalog database.
• Scheduled Oracle Jobs and Backups using CRONTAB.
• Experience in Online and Offline backups and recovery.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Performed Block Recovery and Data file recovery using RMAN.
• Involved in Database Security and Auditing to protect databases potentially including the data, the database applications or stored functions, the database systems, the database servers and the associated network links against compromises of their confidentiality, integrity and availability.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Performed data refresh at Schema level using EXPDP.
• Daily Health Check Up of the Database and SQL Queries using AWR, ADDM and TKPROF.
• Tuned the performance of the SQL’s using TKPROF and STATSPACK reports.
• Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Query optimizing using CBO (Cost Based Optimization) and RBO (Rule Based Optimization)
• Performance Tuning for the SQL queries which are Running slow and taking more CPU cost
• Involvement in day-to-day activities like Space management, rectification of Lock problems, managed quotas, Table partitioning to improve I/O access.
• Alert log Monitoring for critical databases every day in the production environment
• Managing/Troubleshooting MySQL 5.0.22 and 5.1.24 in production and developer environments on both Linux (5.0, 5.1) and Mac OS X.
• Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
• Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.
• Ensured production data being replicated into data warehouse without any data anomalies from the processing databases.
• Worked with the engineering team to implement new design systems of databases used by the company.
• Effectively configured MySQL Replication as part of HA solution.
• Designed databases for referential integrity and involved in logical design plan.
• Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor
• Installed and configured MySQL on Linux and Windows environments.

Environment: SQL Server 2005, SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, MSE, ME Change Request, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler, Oracle 11g/10g, HP-UX 7.x/11.x, RHEL 5.x, ASM, OEM, RAC 11gR2, RMAN and Data Guard, Explain Plan, SQL Developer, MYSQL