SUMMARY:

• Over 7 years of Experience in SQL Server Database Administration, System Analysis, production, QA and UAT environments and support of 32 - bit, 64-bit MS SQL Servers 2012, 2008 R2, 2008, 2005,
• Expertise in Installation, Upgrade, Configuration and Migration of MS SQL Server in clustered and non-clustered environments.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Experience in Database Modeling includes Logical and Physical Design of Databases using Microsoft-Visio.
• Experience in implementing Disaster Recovery (DR) and High Availability Solutions (HA) using Database Mirroring and Log Shipping.
• Expert in SQL Server database Performance Query Optimization, Client/Server connectivity, DB consistency checks using DBCC.
• Experienced in Design, Testing, Implementation and production of Client/Server, and Web based applications.
• Experience in Migrating from SQL server R2 and 2005/2008/ 2008 R2 to 2012 by using side-by-side and in-place upgrade process, and documented the Upgrade Process.
• Working as a Sr. SQL server and MYSQL DBA and manage all the servers and lead the team of 6people.
• Administration and management of the entire development, QA and Production environment.
• Installed and configured MYSQL on Linux environments and SQL server on windows environment.
• Managing/troubleshooting MYSQL 5.6.11 and 5.6.19 and SQL server 2008 r2/2012 in production and developer environment.
• Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
• Increased database performance by utilizing MYSQL Config (my.cnf) 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.
• 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.
• Developed stored procedures, triggers in MYSQL and SQL server for lowering traffic between servers & clients.

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

Sr. SQL Data Base Administrator

Responsibilities:

• Highly worked on Administration, Database Design, and Performance Analysis on very large and highly transactional production databases.
• Installed and configured SQL Server 2014/2012 on new servers with service packs.
• Support and troubleshoot very large databases (VLDB) with 50 GB to 3 TB.
• Extensively worked on Snapshot and Transactional Replication.
• Migrated SQL Server 2008 R2 to 2012/2014.
• Implemented Always On, HA and worked with 2014 new concepts like Delayed Durability, Partition-Table Parallelism, Data Compression, Table and Index Partitioning, Buffer pool extension, Resource Governor for scalability and Performance enhancements.
• Created jobs in SQL 2008 R2 and navigating the path of the object using Windows Power Shell
• Used methods from SQL Server Management Objects (SMO) models to perform actions on the object with the help of Power Shell
• Used PERL scripting for creating tables, Inserting Data and connecting PERL provider from Linux to SQL server 2008 R2/ 2012/2014
• Reconfigure the default locations of the data files, log files and error log files onto the SAN environment for all the servers.
• Work with tools like SQL Server Agent, SSCM, SMO, Database Tuning Advisor, SQL Server Dashboard, SQL Profiler and Activity Monitor for event monitoring and performance monitoring, and make recommendations based on the results.
• Involved in ETL process under development, testing and production support environments.
• Extensively use SSIS tool to load data from MS Access, Excel spreadsheets, and flat files into the target SQL Server database.
• Implement various Data Flow Transformations, such as Copy Column, Row Count, Merge Join, Aggregator, Sort, and Lookup.
• Fix data issues and write various SQL scripts and procedures for migration process.
• Expert in using and implementing DMV’s, DMF’s, data partitioning, DDL triggers, Mirroring and Online indexing.
• Develop all the required stored procedures, user defined functions, and triggers using T-SQL and PL/SQL.
• Implement data availability solutions like online Restore, Online index Operation, Database Snapshot, and Fast Recovery.
• Optimize the performance of queries with modifications in T-SQL queries, remove unnecessary columns, eliminate redundant and inconsistent data, and normalize tables.
• Responsible for transferring packages using SSIS (ETL).

Environment: SQL Server 2008R2/2012/2014, T-SQL, Windows 64-bit, DTS, SSIS, Red Gate, Profiler, MOM, VB.NET, .NET FRAMEWORK.

Confidential, Midland, Michigan

Senior MySQL DBA

Responsibilities:

• Production, Staging, QA and Development Support for Kenexa/IBM application Oracle databases. Support of Oracle RAC 11g, Oracle RAC 9i, Oracle RAC 10g.
• Installed and configured Oracle Database Appliance (X4-2), Use of ILOM, OAKCLI, Deployed on Virtualized Platform, Using ODA BASE Template, Configured Oracle Auto Service Request,
• Installed Oracle Grid binaries and Oracle Database, Setup and configured Oracle RAC, Shared Repositories, Configured Linux OS, Applied Oracle Patches of Used ODA for Production Web Oracle Applications Maintained ODA in Stage and Production of Oracle Data Migrations (9i to 11g).
• Oracle Archiving, Oracle Partitioning o ADRCI/ Logrotate for Oracle maintenance log files, listener, alert logs o Installation, configuration and support of Oracle Distributed Document Capture
• Install database and configure / server configuration Creation of application pools Configure capture security o Installation, configuration of Change Data Capture (CDC), Capturing change data Publish and subscribe Modes, Asynchronous Auto-Log Publishing, Distributed Hot-Log Change Data Capture Maintaining and managing.
• Installation, support of MySQL 5.5.27, 5.6.X Use of MySQL Workbench for administration. MySQL Enterprise Backup - Innodb/MyISAM backups of MySQL DB's
• MySQL Clustering, MySQL Replication of Support, administration, installation upgrades of MySQL on Linux/SE Linux o Shell scripting/Linux for MySQL automated processes.
• Linux/Unix shell scripting and automating of monitoring systems, disk usage, resources, ASM (Capacity Planning, Forecasting).
• Oracle Enterprise Manager 12c monitoring of production, stage, QA and Development Oracle Database Instances.
• Migrated Oracle 11g Database (2 TB) to Microsoft SQL Server 2012 to Use Microsoft SSMA (SQL Server Migration Assistant for Oracle … Project (OracleToSQL).
• Mapping of Oracle and SQL Server Data Types Converted 50 Oracle 11g Schemas to Microsoft SQL Server 2012 Schemas Used Microsoft SSIS to cleanse/massage data from Oracle 11g to SQL Server 2012 Loading Converted Data from Oracle 11g to Microsoft SQL Server 2012 Assessment Reports Backup and recovery procedures/jobs.
• Converted PL/SQL Procedures, Functions, Packages to SQL Server Stored Procedures to Performed in DEV, TEST and Production environments.
• Oracle Database upgrades, patches.
• Staff meetings, team meetings, technical documentation, and training.

Confidential, Nashville, TN

Senior Oracle DBA / Microsoft SQL Server DBA

Responsibilities:

• Provide Arrow ECS with SI and Professional Services for Oracle Support, to include various databases technologies such as Microsoft SQL Server, MySQL.
• Work with Sales in Scoping calls with partners/VARS and customers/Pre-Sales Engineering and develop Statements of Work (SOW).
• Project Management/PMO and Technical Lead for all ongoing projects.
• Pre-screening of technical resources and hiring for projects Method Care - Contract (Arrow ECS) - 2 weeks.
• Performed Microsoft SQL Server Assessment on 4 production servers and 4 Quality Assurance Servers.
• Provided as Built and recommendations Sugar Foods - Contract (Arrow ECS)- 3 weeks.
• Setup Microsoft SQL Server Log Shipping for Disaster Recovery in Production environment.
• Provided end-user as builts and documentation Ariad Pharmaceuticals - Contract (Arrow ECS)- 4 months.
• Installed and configured NetApp Snap Manager and Remote BLOB Storage for backup and recovery of Share point and Microsoft SQL Server in QA/Test and Production.
• Provided end-user as built and documentation.
• Using Light Switch / .Net for Rapid Application Development for front end Microsoft SQL Server / SQL / Procedures for Microsoft SharePoint 2013 Federal Home Loan Bank - Contract (Arrow ECS) - 5 months.
• Migrated Oracle 11g Database (700GB) to Microsoft SQL Server 2012 o Used Microsoft SSMA (SQL Server Migration Assistant for Oracle …,

Confidential, New York, NY

Senior Oracle DBA/ Microsoft SQL Server DBA

Responsibilities:

• Responsible for administering and supporting 15 production Oracle 11g instances in a 24x7 environment of Sun Solaris (OS), Supporting over 9000 users world-wide.
• Upgraded Oracle 9.2.0.7 data warehouse to Oracle 11g (8 Terabytes).
• Focusing on Exadata administration. With nodes ranging from 2 to 8 and incorporating Data guarded Exadata clusters for maximum availability.
• Disaster recovery of Exadata Data guard Physical Standby. Failover/Switchover/Loss of service/Rebuild/ Corruption/Loss of data file testing.
• Proficient in configuration/maintenance/support/dataguard/backup/recovery/failover/switchover.
• Proficient with Rapid SQL (RAD) for SQL procedures / developing Rapid SQL for Microsoft SQL Server and Oracle.
• Implemented/Installed and configured Oracle Exalogic Elastic Cloud: o Oracle Weblogic, Oracle Coherence, Tuxedo, Exalogic Control, Exalogic Hypervisor on Oracle Exabus o Oracle Linux Virtualized Environment.
• Supported Oracle Exadata/Exalogic on Oracle RAC 11g in a multi-node environment.
• Installed, configured and supported Oracle Database Appliance in a (4) node RAC configuration o Oracle Enterprise Linux.
• Supported and configured Oracle Recovery Manager for production backups.
• Supported Oracle 11g Development and QA environments.
• Supported Unix Shell scripts / CRON jobs for nightly re-builds and data loads for Oracle production databases.
• Installed and configured Oracle Enterprise Manager 11g Grid Control for monitoring and DBMS jobs.
• Configured Oracle Data Pump for unloading and loading data to Oracle data warehouse o Configured parallel streams for performance.

Confidential

SQL Server Database Administrator.

Responsibilities:

• Administering the MS SQL Server by Creating User Logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Perform Full Backups and Transaction Log Backups. Restore them whenever necessary. Creating back up strategies and scheduling them for execution.
• Managing of database objects like Tables, views, indexes.
• Worked with stored procedures for data set results for use in Reporting Services to reduce report complexity and to optimize the run time. Exported reports into various formats and resolved formatting issues.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Created views for easier implementation on web pages, and wrote triggers on those views to provide efficient data manipulation.
• Backing up entire user’s database and scheduling backup process.
• Successfully resolved deadlock issues by creating traces on objects using SQL Server Profiler.
• Worked with DTS to load text files to SQL Server.

Confidential

Jr. SQL Server DBA

Responsibilities:

• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Involved in performed data conversions from flat files into a normalized database structure.
• Involved and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Involved in Performance of development support, document reviews, test plan, integration of the system.
• Involved in Maintenance of Indexes for fast and efficient reporting process.
• Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Involved in Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.

Environment: Windows, SQL server, T-SQL, Query Analyzer, Data Transformation Service.