SUMMARY

• 10+ Yrs. of experience as Database Administrator.
• Experience with software development life cycle (SDLC) and project management methodologies.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server Azure - MI/ 2017/2016/2014/2012/2008 R 2/2005/2000.
• Certified Database Administrator (MCITP\MCTS\MCDBA)
• Experience in Data Transformation Services (SSIS), OLAP Services.
• Involved in Migrating the SQL Server 2008 to SQL Server 2012/2014/2016/2017 (Side by Side and In-place Upgrades).
• Proficient with SQL Server tools, including Enterprise Manager, Management Studio, Query Analyzer, Profiler, SQL Server Agent, DTS, SSRS and SSIS.
• Extensive experience in Capacity planning, Maintenance planning, Performance Tuning and Disaster Recovery.
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including SQL Server Log shipping and SQL Server clustering.
• Strong programming skills in SQL*PLUS, PL/SQL for developing cursors, stored procedures, functions, packages and database triggers.
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Data migration using DTS services across different databases like Oracle, MS Access and Flat files.
• Experience in Database Mirroring and Snapshots.
• In-depth knowledge of T-SQL (DDL and DML), Stored Procedures, Triggers, Indexes and Views.
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
• Experience in implementing types of Replication Models like Snapshot, Transactional and Merge.

TECHNICAL SKILLS

SQL Server Tools: SQL 2017/2016/2014/2012/2008 SSMS, SSIS, SSRS, SSAS, Enterprise Manager, Profiler, Query Analyzer, Export & Import (DTS)

Databases: MS-SQL Server 7.0/ 2000/2005/2008 , MS Access 97 & 2000, Oracle 8i & 7.x

Reporting Tools: Crystal Reports, Oracle Reports, SQL Server Reporting Services, Business Objects XI R2, MS Visio 2003/2007.

Languages: T-SQL, C, C++, PL/SQL, Visual Basic 6.0/5.0, VB Script, Power Shell

Operating System: Windows NT 2000 Server/ Server/ Server 2003/Professional/ 4.0, Win XP Prof/Standard, Win 98, HP Unix 10.x, Solaris 8.x and Unix.

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

SQL SERVER Production DBA

Responsibilities:

• Installed and Configured SQL Server 2017/2016/2014/2012/2008 ( R2) /2005/2000 with latest service packs, patches, DBMail and Backup Maintenance plans.
• Upgraded the existing SQL 2000/2005/2008 (R1) database to SQL Server 2008(R 2)/2012/2014/2016.
• Configured SQL AlwaysOn (2012/2014/2016 /2017 ) on multi node clusters.
• Created Database Snapshots to delta load data from the snapshot database to the report database.
• Configured multi node windows failover cluster with dedicated storage to setup SQL AlwaysOn (2012/2014/2016 ).
• Involved in Database Administration, Query Performance tuning.
• Tuned SQL queries to improve the data retrieval on web applications.
• Configured default and Sub clients to backup SQL DB using commvault version 9.0 R2 (Simpana).
• Created Transactional Replication, Pull Subscription and defined editions to transfer data from branch to head office and vice versa.
• Created Indexes and involved in Performance tuning.
• Incorporating business logic in SSIS while converting from Oracle, MS Access and Text to SQL Server. Creating new database/tables to put in the extracted data and rebuilding the relationship.
• Installed and configured Solarwinds and managed 300+ SQL instances.
• Performed upgrades from SQL server 2008 & R2 to SQL server 2008R 2/2012//2014/2016/2017.
• Using SSIS, building high performance data integration solutions, including extraction, transformation.
• Delivered recommendations on improving design, consolidation to a single forest and domain, network response and migration abilities.
• Configured two Active/Passive Clustering setups for failover on production servers. This included installing windows cluster service and SQL 2000 on windows 2003 enterprise edition.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Making a Report as per user requirement using MS Reporting Services 2005/2008.

Environment: MS SQL Server 2000/2005/2008 R2/2012 Enterprise Edition, T-SQL, MS Excel, SSIS, SSRS, Quest Spotlight, Clustering, Replications, Sampan Commvault, MS Visual Studio .Net, C#, VB, Visio 2007, XP Professional.

Confidential, Denver, CO

SQL SERVER Production DBA

Responsibilities:

• Installed SQL Server 2008 on Development environment ensuring zero downtime.
• Installed and Configured SQL Server 2005 and Microsoft Operations Manager 2005 (MOM 2005).
• Upgraded the existing database to SQL Server 2005.
• Created Database Snapshots to delta load data from the snapshot database to the report database
• Cloning database from hot full backup using Symantec backup system recovery 8.0
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views.
• Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.
• Architecture Principles of Web-Enabled Oracle and SQL Server Applications.
• Actively involved in data warehousing of the XML onto SQL SERVER 2005.
• Installed and configured Quest Spotlight monitoring tool to maintain multiple SQL instances.
• Backup and recovery procedures for remodeled databases and implemented automated jobs for database backup.
• Incorporating business logic in SSIS while converting from Oracle, MS Access and Text to SQL Server. Creating new database/tables to put in the extracted data and rebuilding the relationship.
• Consolidated and virtualized multiple physical SQL servers to single virtual machine.
• Performed upgrades from SQL server 2000 to SQL server 2005 and applying windows patches and SQL service packs and security patches.
• Using SSIS, building high performance data integration solutions, including extraction, transformation.
• Day-to-Day monitoring of the event logs and server logs for troubleshooting.
• Created SSIS Packages to migrate the data from database to Text files. Also migrated DTS packages to SSIS packages.
• Configured two Active/Passive Clustering setups for failover on production servers. This included installing windows cluster service and SQL 2000 on windows 2003 enterprise edition.
• Served as Developer and Business Analyst for requirements gathering effort for N-tier ASP.NET enterprise application for campaign finance reporting system.
• Mapping from One Record Type to many using Pervasive Data Integrator.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Making a Report as per user requirement using MS Reporting Services 2000/2005/2008

Environment: MS SQL Server 2000/2005/2008 Enterprise Edition, T-SQL, Quest Spotlight, MS Excel, SSIS, SSRS, Clustering, Replications, MS Visual Studio .Net, C#, VB, Visio, XP Professional.

Confidential, Broomfield, CO

SQL Server Production DBA

Responsibilities:

• Installed and Configured SQL Server 2005 and also Upgraded the existing database to SQL Server 2005.
• Involved in Migrating data from Oracle database to SQL databases.
• Division of roles and responsibilities, a segregation of duties between logical DBAs (SQL Developers) and physical DBAs that prevents single DBA from unauthorized alterations
• Loading Existing Map Files in Easy Loader using Pervasive Data Integrator.
• Migrated large amount of data to Excel 2003 and 2007 using DTS, SSIS and Automated on hourly basis.
• Worked on Clustering environment and configured SQL server cluster groups as high availability solutions.
• Involved in DTS Package, DTS Import/Export for transferring data.
• Involved in implementation of replications like Snapshot and Transactional.
• On call 24/7 support to databases on weekly rotation.
• Scheduled and created Maintenance plans on Prod database.
• Created SSIS Packages to migrate the data from database to Excel files.
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration . Security and architectural planning issues met as well as testing and training.
• Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.
• Developing server side transaction based process for encryption and certificate exchange.
• Managed security and database alerts using Quest Spotlight v3.0 monitoring tool.
• Managing security, which includes monitoring and controlling database access, assigning permissions to application owners.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services (SSIS)
• Helping application teams in query analyzing and its optimization. Coordinating with users for downtime and maintain the system 24X7 running.
• Involved in SQL Server Cluster and Database Mirroring implementation.
• Involved in writing VBScript in DTS using ActiveX Task.

Environment: Windows 2003/2000/NT4.0, ASP, VBScript, MS-SQL Server 2005/2000, SSIS, SSRS, Quest Spotlight, System Monitor / Performance Monitor, Oracle 9i, DTS, Performance Tuning, Clustering, Crystal Reports.