Sr. Principal Database Administrator Resume Profile Herndon, VA - Hire IT People

Areas of Expertise in:

Summary:

Over 7 years of intense experience in SQL Server development and administration.
Experience in installing, configuring, upgrading, migrating different SQL Server editions/versions
Experience in database design, implementation and maintenance
Expertise implementing High Availability-Disaster Recovery solutions
Expertise in performance tuning, monitoring and query optimization
Experience in troubleshooting applications' performance related problems
Experience building SSIS/DTS packages for Business Intelligence/ Data warehouse environments
Build reports using SSRS to serve business requirements

Technical Skills in:

Languages : C, C , T-SQL, HTML, Java, VBScript
Monitoring Tools : Perfmon, DMV, EE, IDM, SAM AppInsight, Zabbix, Graphana, Confio Ignite DTA
Auditing Tools : Idera Compliance Manager, Idera Secure
Comparison Tools : RedGate SQL compare SQL data compare Data Generator, Windiff, TableDiff
Version Control Tools : Serena version control, SVN, Perforce, TFS, VFS
ETL Tools : Import Export Wizard, SSIS, DTS, Informatica
Job Scheduling Tools : Tivoli Enterprise Scheduler, Tidal Scheduler, SQL agent
Operating Systems : Windows Server 2000, 2003, 2008, 2008 R2, Datacenter, Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential

Sr. Principal Database Administrator

Accomplishments:

Consolidate and migrate individual physical SQL servers from SQL 2005 to SQL 2008R2 into Multi-Node, Multi-Instance failover Cluster with cross datacenter mirroring to achieve High Availability and Disaster Recovery.
Achieve 99.99 of uptime in application, multi node multi instance clustering solution have freed up datacenter space and saved over 2 million dollars by moving promise storage to SAN environment.
Optimize the performance of maintenance plan and achieve 85 performance improvement.
Revisit and redesign disaster recovery strategy and create a run book to maintain 99.99 up time.
Clean up large legacy tables over 1 billion records from various environments and implemented partition strategy to manage or archive data efficiently.
Clean up unused expensive and duplicate indexes from production databases to improve performance of DML operations and better management during index maintenance
Automate adhoc processes and save resource time
Documented server configurations, cluster environment, adhoc processes, backup/restore frequencies

Confidential

SQL Server DBA/Developer

Accomplishments:

Automated adhoc reporting request into SSRS reports Customer were able to pull out their information in form of reports by passing different criteria without asking help from support group
Created various stored procedures and SSIS packages saved tremendous amount of hours for sales team members who were inserting and/or updating 1000's of records manually

Confidential

SQL Server DBA

Infovision Technologies Inc. is a leading consulting company it helps building a solution and provides support on existing systems for their clients.

Confidential

SQL Server DBA/ Application Developer Adv.

Accomplishments:

As subject matter expert on legacy systems, migrated legacy SQL Servers: Version 2000 to 2008 with better Hardware.
Optimized a stored procedure running behind the Access application and obtain 96 improvement. Stored procedures had 20 Joins and 4 tables had around 600 to 800 million of records. Created appropriate indexes and statistics by using Database Tuning Advisor DTA Customer was able to pull out the reports in 6 minutes instead of 24 Hours.
Optimized DTS packages running from 7 days to 1 day, there were total of 30 sub packages inside the main DTS package, I removed the unnecessary steps and optimized SQL inside execute sql task Customers were able to pull out the data from data warehouse 1 week early which made providers very happy and satisfied.

Confidential

SQL Server DBA

Accomplishments:

Successfully migrated around 45 production SQL Servers from version 2000 to SQL 2005, actively involved in entire planning of migrating SQL Servers from Boston, MA to Stamford, CT

Confidential

Software Engineer/Quality Analyst

PSPL is providing offshore support for different clients in USA, UK, and Australia. Company builds a solution including developing an application, maintaining and support after production release. As a Software engineer and Quality Analyst, I have tested different applications, generated test cases

Confidential

SQL server/JSP Developer Intern

Ultra InfoTech is a premier IT service provider since a decade to clients globally. It offers unique solutions to build integrate and manage IT systems. As an Intern, my responsibilities included designing, developing portion of a web based portal HOSPITALITY ADMIN : Airlines and Cars' online booking.