OBJECTIVE:

• To seek a challenging position utilizing my 15+ Years of strong experience including Senior MS SQL DBA, Data Modeling, Clustering and replication.
• Experience in Visual Basic 6.0, HTML, DHTML, XML, WML, VBScript, JavaScript, Active Server Pages, .NET

SUMMARY:

• Senior MS SQL DBA (Production and Development), Data modeler, Dataware house Consultant and NetIQ.
• Worked in SQL Server versions from 6.5 to 2015
• Programming Experience in Visual Basic 6.0, HTML, DHTML, XML, WML, VBScript, JavaScript, Active Server Pages and .NET

PROFESSIONAL EXPERIENCE:

Lead SQL Server DBA

Confidential, NJ

Responsibilities:

• We have around 70 DB servers in Datacenters in USA and we have around 80 DB servers in London,UK.
• Installed and configured SQL Server 2008 R2, 2012 and 2014 on windows 2012,2008, 2003 servers, applied service packs and security fix.
• We have upgraded main trading and demo databases from 2008 r2 to SQL 2012.
• Upgraded databases from SQL2005/2008 to SQL 2012
• Configured Transactional replication on trading database with 3 subscribers with pull subscription.
• Configured the Logshipping/mirroring for keeping the DR databases in sync.
• Configured AlwaysOn with stretch cluster with 4 nodes across 2 datacenters for the production trading database.
• Created/configured the databases for products like Sitecore, GreatPlains, Jira, confluence,Application Xtender and Enterprise Vault
• Worked with application support team/vendors on applying any patches/upgrades.
• We use solarwinds for server level monitoring and DPA (Database performance Analyzer) for DB Level monitoring.
• Worked in data archival on the key tables, which helped in performance improvement.
• Worked in key migrations related to some acquisition of companies like GTX, CityIndex.
• Installed configured Tableau server 10.1/10.2 and 10.5
• Upgraded Tableau from 10.1/10.2 to 10.5
• Worked in performance tuning of the main production Trading database. Time taken for an trade to complete is called DealTime. Worked on improving this and improved it by reducing the deal time from 60ms to 14ms.
• Memory usage on the production server was high and PLE (Page Life Expectancy) was dropping often, we have checked and introduced couple of indexes on some key tables. It reduced the usage of memory and PLE has also improved.
• PLE on the production Trading database was dropping daily at certain time frame, worked on it and found a particular job was causing it and we did tune the procedure called by the job and PLE was not dropping after this.
• Weekly maintenance on the production trading database used to run for more than 16hrs on weekend. worked on tuning this and brought it down to 4hrs.
• Installed and configured SSRS in all environments (Dev, QA, UAT, Staging and prod)
• Worked in Migrating reports from one environment to other based on a release ticket from Jira.
• Worked in configuring the security in SSRS for various sets of reports for different groups.
• Worked in DR testing of multiple database servers and successfully completed the DR test.
• Worked in tuning the performance of the SQL Jobs on critical servers, worked on tuning sql stored procedures, SSIS Packages and off - loading the readonly jobs to secondary replicas.
• When we got a new EMC VMAX storage, Worked on storage migration with system engineers. We migrated all the database servers/databases (around 20TB) from old storage to new storage.

Lead SQL Server DBA

Confidential, NJ

Responsibilities:

• We have totally 414 servers with 673 SQL instances hosting around 54,000 databases. This includes the servers in SQL Farms, silo clusters, Standalone server and VMs. Our SQL Farms are 4 node clusters with multiple instance running on them.
• Worked on key project, which was for vacating 4 hubs (Alpharetta,Chicago,Roseland and Sandimas) and migrating the databases to SQL Farms in datacenters- DC1/2.
• Worked with Vendor and application teams on the requirements, capacity planning and sizing of their databases on the SQL Farm for all environments including DR.
• Configured the Logshipping/mirroring for keeping the DR databases in sync.
• Configured and maintained transactional and snapshot replication between the production servers for two different environments.
• Upgraded the SQL 2008 Servers to SQL 2008 r2.
• Upgraded databases from SQL2005/2008 to SQL 2012
• Upgraded databases from SQL2005/2008 to SQL 2014
• Created and configured the VMWare databases (VCenter, VUM, SRM and VCO)
• Created and configured the BES (BlackBerry Enterprise Server) database and Listserver databases and worked with Application team and vendor on configuration and requests.
• Worked on many application database sizing, planning and creation, some of them are Hyperion, TeamTrack (SBM), Siteminder, GreatPlains, Resource scheduler, MAIN, TLMWEB, Support center,EAS (Enterprice Application systems), Lumin, Bridgeway suite,etc.,
• Worked on performance tuning for key applications like PTS and PSS, both are for Print services and they have heavy load during the year end. Provided temporary solution to finish the year and also provided the permanent solution for future. Monitored and captured the queries running and using high CPUs and worked with application team and suggested rewrite option and some indexes and partition/archiving solution.
• Worked with our team members in different locations (USA, Canada & India)
• Reporting database are configured with AlwaysON secondary replica
• Working with other teams for configuring alwaysOn for DR.

Lead MS SQL DBA (Production Support)

Confidential, NJ

Responsibilities:

• Act as a Lead SQL Server DBA, Provided production support for 320 Servers out of which 190 servers are production servers.
• Installed SQL Server 2008, 2005, 2000 on windows 2008, 2003, 2000 servers, applied service packs and security fix.
• Upgraded the SQL 2005 environments to SQL server 2008 and 2008 R2.
• Upgraded the SQL 2008 Servers to SQL 2008 r2.
• Upgraded databases from SQL2005 to SQL 2012
• Worked on Installing configuring the databases for SAP - BW, CRM, ERP
• Worked on configuring the maintenance plans for SAP BW, CRM and ERP databases
• Worked on upgrading SAP - BW, CRM and ERP databases upgrade from SQL Server 2000 to SQL 2005
• Created database for different projects and created objects like Tables, Views, Sps, UDFs, UDDTs.
• Configured and maintained transaction and snapshot replication between the production servers for two different environments.
• Installed & configured databases for BizTalk Server, Sharepoint Server and Project Server.
• Installed, configured and maintained the log shipping architecture to provide backup server for production environment.
• Lead the SQL Server DBA team to provide production and development support for application team and different clients located in United States of America and Canada.
• Experienced with improving SQL Server performance using performance monitor, index tuning wizards, profiler and execution plans.
• Installed SQL Server 2005 in a test environment and upgrade the SQL Server 2000 databases. Testing the successful upgradation. Experienced with all new features of SQL Server 2005.
• Upgraded CI (Commercial Intellisys) databases from SQL Server 2000 to SQL Server 2005
• Experienced in creating backup strategy for production, development environment and implemented them.
• Experienced in working with SQL Server 6.5 and upgraded the server to SQL Server 2000.
• Upgraded CLDB, CF Forms, Cldb adhoc, TPD weekly and TPD monthly databases from SQL Server 6.5 to SQL Server 2005.
• Installation and configuration of SQL Server Reporting Services in 2000, 2005, 2008 and 2012
• Setting the security for Dev/Prod environment for Reporting Services.
• Deploying/Migrating the reports to Production Reporting Services environment.
• Worked with Developers on RAMS Report (CALR) project & Claims Financial Report (CFR) from the beginning on SQL Server reports and security, .NET and subscriptions configurations
• Worked on the upgrade of RMS (Risk Link & Risk browser) databases to SQL Server 2005.
• Automated the CMS Bordereau monthly process using DTS (Data Transformation Service).
• Worked on moving servers from Morristown to Datacenters
• Worked with SOX auditors for the SOX inscope databases like CMS, CI, Loss reserves, Actuarial, TPD.
• Worked with the vendor (RMS) on performance tunning of Risk Link & Risk Browser environments
• Worked on trouble shooting in various instances for many applications.
• Worked as an Administrator on Informatica Version 8.1.1 and 8.6.1.
• Worked on migrating objects from dev to uat and uat to prod.
• Worked as Informatica Administrator when the primary admin is not available.
• Worked in Informatica 8.1.1 and 8.6.1
• Planning on upgrading from Informatica 8.6.1 to 9.5
• Worked in migrating the code from DEV to uat and to Prod
• Worked on some of the key activities as Oracle Administrator
• Cloning the database
• RMAN Backups and ArchLog backups
• RMAN Restores
• OMS Agent Installations
• Implementing changes in databases on multiple environments
• Automating the database maintenance and scheduling them.
• Monitoring the database performance via OEM
• Generated AWR reports and AWR SQL Reports
• Using AWR reports, advised the developer teams on tuning the code.

Lead MS SQL DBA

Confidential, Groton, CT

Responsibilities:

• Installed, configured and maintained transactional replication One Publisher and 4 subscriber environment for production servers. These subscribers are located in CT, Brazil and NJ.
• Installed, configured and maintained SQL Server Fail over clustering for 3 production environments.
• Installed SQL Server 2000 on Windows 2003 servers. Applied Service packs and security fixes.
• Configured Log shipping for 2 environments to create a Disaster Recovery Stand by servers.
• Created pro active scripts to monitor SQL Servers. These scripts monitor backup, drive space, log, db size and service status monitoring.
• Experienced with FDA regulations for validated systems for Pharma companies requirement.
• Created the backup and restore strategy for production and development environment.
• Responsible for database backup and restore, monitor production servers activity. Problem solving, scheduled jobs, SQL Server error log and space usage.
• Upgraded the SQL 6.5, 7.0 to SQL server 2000 servers.
• Created the physical data modeling using Erwin tool. Configured and maintain transactional, snapshot and merge replications.
• Responsible for Stored procedure optimization, Performance tuning and DTS.
• Involved in tuning the database and server performance. Worked with Profiler to trace and tune the database.
• Experienced with Dataware Housing concepts, Designed Dimensional models schemas like STAR and Snowflake schemas.
• Installed and configured Analysis services for Dataware housing project. Built and process the cubes.

Senior MS SQL DBA (Production Support)

Confidential, Memphis, TN

Responsibilities:

• 24* 7 Critical Production Support for Confidential 100 Production Servers located in USA and Canada. 20 Mission critical applications are running in these servers. There is no downtime for these Servers. Minimum database size is 800 GB.
• Involved to setup Fail over Clustering Architecture for SQL Server databases for mission critical applications. Created Logical data modeling for production database and dataware housing Projects using Erwin Tool. Created the Physical Database design for production database.
• Involved in replication setup, configuration and maintenance in all types of replication like snapshot, transactional and Merge replication. Worked on new features of SQL 2000 user defined functions, Federated database servers, multiple instance of SQL server, fail over clustering enhancements, log shipping, new backup and restore procedures, Internet Integration and OLAP enhancement.
• Created the Production database backup and restore strategy and implemented the procedures. Involved in Database recovery procedures. Involved in tuning the database and server performance. Worked with Profiler to trace and tune the database.
• Upgraded experience from SQL 6.5 to 7.0 and From SQL 7.0 to 2000. Installed and Configured SQL 2000 on WINDOWS 2000 system. Configured and maintain a Microsoft SQL server2000 fail over cluster. Worked on Log shipping, Data Transformation services (DTS).
• Experienced with Dataware Housing concepts, Designed Dimensional models schemas like STAR and Snowflake schemas.
• Monitored the database from the corporate office. Used to get alerts from NetIQ application.
• Installed and configured Analysis services for Dataware housing project. Built and process the cubes. Configured the security roles to the OLAP environment. Created and used the Data mining models. Optimized the dataware housing environment.
• Installed and configured SQL Server CE version in PDA.
• As a Lead DBA, lead the Database Administration team to install, configure and maintain the Production environments for mission critical applications. Involved in Strategic planning to initiate new projects.

MS SQL DBA

Confidential, CO

Responsibilities:

• Responsible for production support and Migration.
• 24* 7 Critical Production Support for national level Confidential 110 Production Servers all around USA from a Corporate Support DBA Team.
• MCI call centers Sales and Calls handled reports are generated by the System Called DV2 (DELTA Version 2), IIS and CGI Servers are running in the top of SQL Server, the ONLINE Report Is Accessing From all the Call Centers. There is no downtime for these Servers.
• Having upgraded experience from SQL 6.5 to 7.0 and From SQL 7.0 to 2000. Installed and Configured SQL 2000 on WINDOWS 2000 system.
• Worked on Log shipping, Data Transformation services (DTS).
• Experienced with Dataware Housing concepts, Designed Dimensional models schemas like STAR and Snowflake schemas.
• Installed, configured and used Data Protection for Microsoft SQL Server which complements TSM (Tivoli Storage Manager) for database backup and restore operation.
• Worked in Web Assistant Wizard, English query and replication methods like snapshot replication, transactional replication and Merge replication.
• Worked on new features of SQL 2000 user defined functions, multiple instances of SQL server, log shipping and IIS.

Senior MS SQL DBA & Programmer analyst

Confidential

Responsibilities:

• Installed and Configured SQL 2000 on WINDOWS 2000 system. Upgraded from SQL Server 7.0 to SQL 2000.
• Designed Logical and Physical database design using Diagram feature in SQL Server.
• Worked on T-SQL in creating stored procedures, Triggers, tables and Views.
• Worked on Database schema, table creation, index creation. Written Stored Procedures, Triggers and functions for effective data integration for business logic.
• Installed and configured Replication between Production Servers. Created the strategy for production database backup and restore to avoid data loss.
• Involved with Disaster recovery procedures. Created the maintenance script to avoid the Database corruptions and performance tuning.
• Involved in size manipulation of Devices, Databases, Transaction logs, Experienced with Managing user accounts and security Involved in scheduling tasks and Setting Alerts, Managing Task Scheduling, setting up a SQL mail, managing alerts, monitoring and tuning SQL Server, SQL Performance monitoring and Trouble Shooting.
• Configured and maintain a Microsoft SQL server2000 fail over cluster.
• Designed Dimensional models schemas like STAR and Snowflake schemas. Designed and doing support online analytical processing OLAP applications for corporate reporting.
• Designed the Dataware house architecture based on the Enterprise Data Management system that uses the shared Metadata layer across all the stages of Data Warehouse.
• Designed the table structures with proper Indexes, Keys and integrity to provide fast access. For end-user reporting and analysis the data will be stored in cubes.
• Worked on all database administrator activities, Performance tuning, Backup and restore of databases, Disaster recovery, Implemented Database maintenance processes, Index Tuning.
• Installed and Configured MS SQL SERVER 7.0 on WIN NT 4.0.Responsible For Database Design and Production Support for 15-muti location Servers. Maintained the All-14 Servers From a Corporate.
• Extensively involved in the Analysis, design and database modeling. Worked on Data Modeling, Data Elements, Issue/Question Resolution Logs, and Source to Target Mappings.
• Worked on T-SQL in creating stored procedures, Triggers, tables and Views.
• Created the various reports using T-SQL.
• The Web reporting done using IIS and CGI Servers are running in the Top of SQL Server, the ONLINE Report Is Accessing from all the Centers. There is no downtime for these Servers.
• Data’s are Moving Table to table every time. Created the Stored Procedures and triggers for Effective Data Movement.
• Experienced with the Production Database Backup and Restore, Disaster Recovery methods. Experienced Database Replication.
• Experienced with All DBA routine activities Query Optimization, Performance Tuning, Effective SQL Server Configuration, and Routine Database Maintenance for avoiding the Database Corruptions.