SUMMARY

• 7 years of professional IT experience with a focus as a SQL Server DBA in enterprise environments.
• Proficient at implementing disaster recovery strategies, performing database backup/recovery, restoring, monitoring, and performance tuning.
• Experience addressing a variety of database integration issues including: migration between disparate databases, integration, maintenance / conversion, capacity planning issues, and new applications.
• Adept at creating and maintaining SSIS packages, setting up/schedule jobs and database structure checks and Administering SQL Server Analysis Services and Reporting Services.

TECHNICAL SKILLS

• Platforms, WindowsIBM
• Red Hat LinuxUNIX, Database
• SQL Server 2000/2005/2008/2008 R2/2012
• SSIS/SSRS/SSAS
• Sybase IQ, Oracle10g
• Software & Tools
• MS Office SuiteLiteSpeed
• MS Visual Studio 2008 ESM
• RedGate SQL Compare Remedy
• Double TakeRed Gate
• Veritas NetBackupQuality Center
• QuickTest Pro (QTP)MaximoSAN
• Idera Diagnostic ManagerXenApp Citrix Team Foundation Server Peregrine
• Sharepoint Impact
• Idera SQL Safe SQL Sentry
• Idera Compliance Manager

PROFESSIONAL EXPERIENCE

Confidential

SQL Database Administrator

Responsibilities:

• Supporting 350+ production and non - production servers (SQL 2000, 2005, 2008, 2008R2, 2012) in both OLTP and OLAP Environments and Databases from 4GB to 20TB.
• Hands on experience implementing high availabilitysolutions, including replication, clustering, log shipping and Mirroring.
• Utilize third party monitoring tools like Idera diagnostics manager to proactively monitor application issues related to Application timeouts, long running queries, locks e.t.c
• Supporting all script Deployment and cube processing on SQL Server Analysis Server as well as Report deployment on SQL Server Reporting Server.
• Responsible for all administrative and troubleshooting issues on SQL Server Analysis and SQL Server Reporting Server.
• Implement New Server Builds, everything from Hard Drive Configuration, installing Idera Diagnostic manager agent and Idera SQL Safe Backup, Setup Performance traces, Request ports to be opened, Installing and configuring SQL Server and applying all related patches and Hotfix.
• Perform weekly Health Checks on all Prod and Non-Prod Servers.
• Implement database Encryption on PCI Prod Servers.
• Managing very large databases (VLDB) over 20TB for OLTP and 22TB for OLAP
• Support and administration of Sybase IQ Databases.
• Responsible for agent and replication job monitoring, failed job analysis, resolving space issues, log shipping, backups, resolving bottlenecks in production environment and user maintenance/ adhoc requests.
• Install, Configure and maintain SQL Server in a cluster environment in active-active and active-passive mode.
• Coordinate reporting server production releases with Development team using Team Foundation Server 2008.
• Implement Database Change Controls & Service Requests via applications like Remedy and Help develop and validate the database implementation plan.

Confidential

SQL Database Administrator

Responsibilities:

• Lead the efforts of installing and maintaining database management software.
• Supported 250+ production and non-production servers (sql 2000, 2005, 2008, 2008r2) in different locations daily and involved in emergency procedures to resolve issues.
• Implemented disaster recovery strategies with double take, perform database backup/recovery and restore with quest litespeed and sql server management studio.
• Implement Database Change Controls & Service Requests via applications like Peregrine, Maximo, Remedy e.t.c and Help develop and validate the database implementation plan.
• Resolve Database related trouble tickets assigned to the DBA group.
• Support the data loads into the databases.
• Ensure dat the application, and any enhancements, interacts efficiently with the database.
• Develop and implement database performance monitoring process and analyze monitoring data for performance optimization opportunities.
• Create/Implement database maintenance plans to ensure data integrity.
• Plan for and execute any required database upgrades and migration (patches etc.)
• Configure, troubleshoot and resolve transactional replication issues.
• Requested changes, updates and modifications to database structure and data.
• Ensured database integrity, stability and system availability.
• Reviewed and performed database tuning, analyzed results, provided recommendations and implemented solutions for improvement.
• Provided critical input in the development, maintenance and testing of a corporate-wide Disaster Recovery plan.
• Ensured dat disaster recovery processes are adequate for all new business applications.
• Monitored and managed database backups, logs, and journals; installed, maintained, and upgraded database software; restored and/or recovered data as required.
• Developed and maintained current written documentation for all databases.

Confidential

SQL Database Administrator

Responsibilities:

• Provided Remote 24x7 on call support and problem resolution as necessary.
• Supported 2000+ production and non production servers in different locations.
• Installed both stand alone and clustered sql server.
• Implemented disaster recovery strategies, perform database backup/recovery and restore.
• Monitored relational databases to optimize database performance, resource use, and physical implementations of databases.
• Performed healthcheck on the Dbserver to minimize exceptions during business hours.
• Addressed a variety of database integration issues including: migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications.
• Monitored database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.).
• Installed and patched server software; upgrade and downgrade databases.
• Set up alerts, operators, SQL Mail, SQL Agent Mail, and notifications.
• Created and maintained SSIS packages.
• Set up and schedule jobs dat performed backups and database structure checks.
• Configured Replication, Log Shipping, and Failover clustering to meet customer needs for production environment to development environment.
• Moved, transformed, and loaded heterogeneous and homogeneous into SQL Server databases, as well as export SQL Server data to text file and other database systems.

Confidential

SQL Database Administrator

Responsibilities:

• Managed the Production to Development DB Refreshes based on requirements.
• Monitored, tuned, backed up, recovered/restored databases.
• Setup servers, new databases and testing environments.
• Performed security, maintenance, and database consistency checks.
• Analyzed and tune databases to ensure optimal database and application performance.
• Assisted applications developers in stored procedure construction, SQL tuning, and provide performance analysis.
• Participated in planning, testing and performing major upgrade of SQL Server.
• Designed and supported high availability SQL Server solutions dat include Log shipping, Replication, clustering and SAN replication.
• Created and maintained DTS and SSIS packages.
• Compiled detailed reports using data reporting tools, such as SQL Server Reporting Service.
• Monitored MS SQL Servers for errors and performance degradation.
• Worked closely with applications development to ensure database design meets business requirements.
• Involved in troubleshooting, resolved data integrity and performance issues.
• Installed, tuned and maintained all Microsoft SQL Server database systems.
• Maintained SQL Server with the latest patches and updates.
• Assisted application developers in database access techniques and resolving connectivity issues.

Confidential

SQL Database Administrator

Responsibilities:

• Configured and tested backup and recovery of databases
• Responsible for installing and upgrading sql server and ensuring the success of each upgrade.
• Performed security, maintenance, and database consistency checks.
• Worked as a team member with other DBA’s to ensure 24/7 support of all corporate databases.
• Proactively monitored, identified, and resolved server problems to avoid impact on the business.
• Configured sql server on both clustered and non-clustered environments.
• Responsible for assigning users to databases and determining the proper security level for each user.
• Participated in major deployment and migration projects.
• Ensured maintenance plans were executing successfully and resolved any maintenance job failures.
• Applied security patches to databases and maintained appropriate security measures.
• Utilized sql profiler for troubleshooting slow running queries and performance issues.
• Performed database refreshes in development environment.
• Scheduled and executed SSIS packages in both sql sever 2000 & 2005.

Confidential

QA Analyst

Responsibilities:

• Coordinated with the development team to design and develop Test Plans and Test Procedures.
• Worked closely with developers in re-creating testing scenarios so dat defects are captured in a timely manner.
• Used Requirement Documents to create Test Cases and Test Scripts.
• Developed Test Cases to cover overall functionality testing and integration testing of the interface.
• Used Quality Center to track and report system defects and fixes.
• Documented, tracked defects and usability issues, followed up with development team on reported defects and ensure timely resolution.
• Conducted user acceptance testing (UAT).
• Provided metrics and testing status to management on a weekly basis.
• Advocated quality by ensuring critical/ high severity defects are monitored through the use of traceability matrix and are not deployed in production.
• Ensured the resources and tools are available prior to test entrance.