SUMMARY:

Senior SQL Server Architect\DBA\Developer with over fifteen years of experience in SQL Server 2014/ 2012/2008/2005 database administration, database development, database troubleshooting, performance tuning, database design and ETL design.

Currently working at Everest Insurance on administration and support of SQL Server/MYSQL databases.

Worked at Ingram Confidential, Confidential, Confidential, NBC and other clients on various production and development DBA roles involving clustering, replication, log shipping, ETL development and administration, mirroring, backup and recovery, production support, database design, performance tuning, etc. for multiple SQL server database servers.

Experienced in MySQL, Oracle administration as well.

TECHNICAL SKILLS:

DBMS: MS SQL Server 2014, 2012/2008R 2/ 2008/2005/2000, MySQL 5.8, Sybase 10/11, Oracle 11G

OS: Windows, UNIX, Linux

Tool: /Languages: DTS, SSIS, SSRS, AWS, ASP, VB, COM, .NET, PHP, MTS, SQL, TSQL, XML, ERwin, Visual Source Safe, GoldenGate, Quest Foglight, Idera, NetIQ, SQL optimizer

PROFESSIONAL EXPERIENCE:

Confidential, Bridgewater, NJ

Senior SQL server DBA/Developer

• Working as Primary SQL Server DBA\Developer in SQL server 2014, 2012 environments
• Installing and maintaining SQL Server database systems.
• Maintaining the database systems to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability.
• Worked with Transparent Encryption for all sensitive databases to enhance security
• Monitoring database performance using SQL profiler (Sever Side Traces) and third party tools like foglight.
• Migration of DB2 databases to SQL Server environment
• Optimization of database using index rebuild, stats update and proper backup strategy.
• Creating scripts using NetBackup client to backup databases directly on tape.
• Worked in Active Active, Active Passive Cluster environment as a High availability solution.
• Setting up service broker for SQL Server's internal messaging system and alerts.
• Resolving Performance issues like deadlocks, frequent blockings, index contentions,
• Query tuning using execution plan, proper Index creation for fast retrieval of data
• Version maintenance and deployment of database scripts using Team Foundation Server
• Identifying performance bottlenecks like high CPU and I/O intensive queries using scripts and query optimization using tools such as database tuning wizard
• Migrating SQL Server databases to Azure cloud environment
• Work with server team to establish optimum memory utilization, VM swap file usage, better cpu speed in virtual environment for mission critical applications
• Proper standards for tempdb performance in case of high tempdb usage by stored procedures
• Interaction with business and development team to understand the scope of the project
• Documentation of daily used scripts, updating system documentation for system and database recovery etc.

Confidential, Mahwah, NJ

Senior SQL server DBA/Developer

• Working as Primary SQL Server DBA and Secondary Oracle/MySQL DBA on 24x7 production support.
• Configuring an AlwaysOn Availability Group for Read - only Routing and high availability on classic failover cluster and GeoCluster configuration.
• Database migration from SQL 2005 and 2008 to SQL 2012
• Proficiency configuring, implementing and support high availability solutions for SQL Server including clustering, replication, mirroring and log shipping for disaster recovery.
• Setup and troubleshoot replication and mirroring issues.
• Performance recommendations which include Data compression, index recommendation and table partition strategies
• Handle SQL 2012/2008/2005 cluster installations and latest service pack and hot fix upgrade for GeoCluster configuration.
• Manage database maintenance plan activities including backups, rebuild indexes, statistics check, integrity and consistency checks, etc.
• Experience with database monitoring tools including Quest Foglight, EMC Networker, and Windows Perfmon tools.
• Automation scripts using PowerShell.
• Build ETL processes utilizing SSIS/DTS, including FTP data from remote location, transform it, mart it to data warehouse and provide proper error handling and alerting.
• Develop reports using SQL server reporting services and utilizing SQL queries and stored procedures.
• Experience with planning and disk configurations for new hardware infrastructure and performance tuning of large size databases of terabytes.
• Performance tuning for slow running queries
• Follow SDLC, Change Control Management of the daily deployment of database code to UAT and production environment.
• Work in rotating shift for on-call production support
• Effective designing of databases including: logical & physical data design, tables, normalization techniques, relationships, primary & foreign keys, and data types,
• Extensive experience writing and performance tuning of T-SQL queries
• SQL Development - ability to write and troubleshoot SQL Code and design ( stored procedures, functions, views, triggers, indexes, constraints )
• Manage Indexes and statistics to improve performance and Confidential requirements.
• Establish SQL coding standards, naming conventions, & data access policies.
• Document company's database environment, processes, & procedures
• Installation, configuration and upgrade of MYSQL databases to version 5.8. on redhat Linux operating system.
• MySQL processes, security management and query optimization.
• Recovering the databases from backup in disasters.
• Linux shell scripting
• Cronjob setup for MYSQL in Redhat Linux 5.0 set up master - master and master - slave replication in MySQL 5.5.8

Environment: SQL Server 2014, 2012, 2008R 2/ 2008/2005/2000, Oracle 10G/11G, MySQL, ERwin, SSIS/DTSTSQL, XML, Quest Foglight Perfmon Analysis Tool, Quest SQL Optimizer, OS Windows Server 2008/2003, Redhat Linux

Confidential, Radnor, PA

Senior SQL server Architect \DBA

• Confidential has multi-platform and database Systems like Oracle, SQL Server, MySQL on Linux and Windows Servers.
• Worked on different features of SQL server such as SQL server 2008 clusters, SQL server transactional replication, SSIS packages, log shipping, mirroring, performance tuning.
• Database administration activities as an on call production support DBA for SQL Server databases for Confidential converged products group.
• Planned and migrated database conversion from SQL Server .
• Collaborated with system architects, design analysts to understand business or industry requirements.
• Designing multiple SSIS packages for retrieving data from heterogeneous systems.
• Creating and maintaining upload scripts to a hierarchical database as part of a data migration using SSIS.
• Creating stored procedure to imports internal XML feeds into a SQL Server 2005 tables.
• Performance tuning of high volume OLTP databases and SQL queries using large tables (> 50 million rows).
• Resolved blocking and deadlocking issues in concurrent queries.
• Database modeling, Database architecture and normalization techniques.
• Involved in SQL Server database installation (cluster\standalone), maintenance and follow guidelines as per Microsoft standards and SOX security guidelines.
• Setup and configured SQL 2005\2008 Cluster in active\active and active\passive mode.
• Setup backup and recovery strategies for SQL server databases.
• Deployment of Microsoft standard maintenance jobs for optimization of databases like re-indexing, index defrags, updates statistics.
• Perform capacity planning and disk configurations for new hardware infrastructure.
• Performance tuning and optimization of SQL Server database and quires.
• Implemented table partitioning to improve performance and data management.
• Transactional peer - peer replication setup and troubleshooting.
• Developed SSIS package to refresh data from production.
• Knowledge of windows OS administration and network topologies.
• Alert notification setup and Monitoring SQL servers using Idera monitoring tool.
• Setup log shipping for disaster recovery.
• MYSQL database administration installation and replication setup
• PHP/ Python scripting

Technology/Software: SQL Server 2008R 2/ 2008/2005/2000, ERwin, SSIS, SSRS, TSQL, XML, OS Windows Server 2008/2003, Linux, Idera SQL Diagnostic Tool, MySQL

Confidential

Senior SQL Server Architect\DBA

• Confidential has database systems like Oracle, SQL Server and MySQL. All applications are spread across multiple Database Instances on different versions of Oracle/MS SQL and on multiple UNIX, Linux, Sun, AIX, Mainframe and Windows Servers.
• Database administration activities as an on call production support DBA for SQL Server databases for EASM supported applications like Estore. Created ER data models for product and pricing data.
• Designed databases to support business applications, ensuring system scalability, security, performance and reliability.
• Developed data models for applications, metadata tables, views or related database structures.
• Designed and developed scripts to refresh selective data from production to development, QA and production support environments.
• Involved in resolving the blocking and deadlocking issues and performance improvement using index tuning and other techniques.
• Involved in SQL server 2005 and 2008 synchronous/asynchronous mirroring.
• Performed capacity planning and disk configurations for new hardware infrastructure.
• Handled SQL 2008/2005 Installations (Cluster and Standalone) and latest service pack and hot fix upgrade.
• Database modeling, database architecture and capacity planning and normalization techniques.
• Code development and optimization (optimizing SQL queries). SSIS development and troubleshooting for data load.
• Worked in SSRS administration and report creation. Performance test using tools like SQL profiler or server side traces.
• Log shipping and replication troubleshooting. Monitoring SQL servers using Idera monitoring tool.
• Implemented table partitioning to improve performance and data management.

Environment: SQL Server 2008R 2/ 2008/2005/2000, SSIS/DTS, TSQL, OS Windows Server 2008/2003, Idera SQL Diagnostic Tool

Confidential

Production Database Support - SQL Server - 2008, 2005, 2000 DBA

• Worked in SQL 2008 upgrade projects and setup mirroring, replication and log shipping on production severs. Worked as a part of Microsoft Management Services (MMS) DBA team for Microsoft SharePoint group which provide services to various Microsoft customers like Nokia, Coca-Cola, etc.
• Database administration activities as an on call production support DBA for SQL Server and part of MMS DBA account managers’ team supporting SharePoint servers.
• Involved in installing SQL server 2005 and 2008 single instance and multi instance Clusters with active/active or active/passive configuration. Built 2 node, 3 nodes and 4 nodes clusters.
• Upgraded from SQL server 2000 and 2005 to SQL Server 2008
• Involved in SQL server 2005 and 2008 synchronous/asynchronous mirroring from scratch. As per the Microsoft MMS standards all the production databases should mirrored to mirror node as a part of disaster recovery.
• On boarding new servers from different BUITS as per the MMS standard including disk offset for better I/O
• Configuring production servers as per Microsoft standards to improve performance.
• Deployment of Microsoft standard maintenance job suite for optimization of databases like re indexing, index defrags, updates statistics and partitioning large tables.
• Performed capacity planning and disk configurations for new hardware infrastructure.
• Handling SQL 2008/2005/2000 Installations (Cluster and Standalone) and latest service pack and hot fix upgrade.
• Troubleshooting and Diagnosis of SQL server alerts.
• Performance tuning and optimization (rebuild index/index defrag/update statistics) of large databases up to 4 terabytes.
• Setting up Mirroring, Replication and Log shipping for SQL Server 2005.
• Disaster Recovery Planning, Backup, Restoration and Recovery in different scenarios.
• Development of DTS and SSIS packages.
• Creation of database schemas, managing user creations, assigning roles to SQL databases.
• Maintaining database documentation at team site.
• Part of tier3 problem management team and account manager for tier1 offshore team (MACSMON).

Environment: SQL Servers 2008/2005/2000, SSIS/DTS, TSQL, OS Windows server 2008/2003, LiteSpeed 2005, Visual Source Safe, Microsoft Office SharePoint 2007, MOM operator console, SCOM

Data Warehousing Development and Database Administration - SQL Server - 2008, 2005, 2000 DBA

• Worked as a part of Remote IT Services (RITS) DBA team for maintaining data warehouse in SQL server and production support for around 600 SQL servers across various product groups and systems like HR and Finance in Microsoft. Business Intelligence and Data Warehousing in SQL Server 2005.
• Development and support for data warehousing in SQL server database system.
• Designing fact and dimension tables for data warehouse database.
• Creating SSIS packages to load data from OLTP database into data warehouse database.
• Database administration activities as an on call production support DBA for SQL Server and part of RITS DBA account managers’ team.
• On boarding new servers from different BUITS as per the RITS standard.
• Handling SQL 2008/2005/2000 Installations (Cluster and Standalone).
• Involved in installing SQL server single instance and multi instance clusters with active/active or active/passive configuration.
• Migration from SQL 2000/2005 to SQL 2008.
• Backup, restoration and recovery in different scenarios.
• SQL server optimization job scheduling and maintenance.
• Partitioning for large tables in SQL server databases.
• Maintaining database documentation at team site.
• Part of tier3 team and account manager for tier1 offshore team (PSITOPS).

Environment: SQL Servers 2008/2005/2000, SSIS/DTS, TSQL, OS Windows Server 2008/2003, LiteSpeed

Confidential

SQL Server - 2005, 2000 DBA

• Database development activities as an Onsite Production Database DBA support for SQL Server 2005/2000.
• Create Stored procedures, triggers, views and functions. Wrote complex queries to create reports.
• Creating performance tests using SQL profiler (client side and server side traces).
• SQL server 2005 installation (including integration and analysis services).
• Database Design: Forward and Reverse engineering of ERD and Schema.
• Handling installation and creation of new SQL server databases. Log shipping (SQL 2000).
• SQL server cluster shared environment (Active\Active, Active\Passive).
• Backup, restoration and recovery in different scenario.
• Monitoring the CPU usage, IO statistics, Memory Usage to identify any OS level performance killers.
• Managing user creations, assigning roles to SQL databases.
• Requirement analysis and capacity planning for database designing, maintenance, update application schema structure/data models/ERDs and relations between objects as per requirement analysis using Erwin.
• Installation of SQL server 2000\2005, applying service packs and hot fixes.
• Development of DTS and SSIS packages, migration from DTS (SQL 2000) to SSIS (SQL 2005).
• Administrator for Hyperion Essbase application. Developing reports using Hyperion Essbase.

Environment: SQL Servers 2005/2000/7/6.5, SSIS/DTS, SQL, TSQL, ERwin, MySQL 5.0, Sybase 10/11, Windows

Confidential

SQL Server - 2000 DBA

• Reservations - Define your customers’ needs and make appointments and reservations, schedule a follow-up, place the customer on a waitlist, or record lost demand.
• Customer Care - Manage a customer’s contact information, accept payments, move customers in and out and view their customer history.
• Products and Services - Sell, return and reverse inventory and enter other income into the system. Letters - Print a letter to an individual or group of customers.
• Revenue Management - Recommend new rates and discounts and learn about the pricing logic.
• SQL Server 2000 on call DBA support and troubleshooting SQL server alerts.
• Installation of SQL server binaries, service packs and hot fixes.
• Maintaining DTS packages, SQL server agent jobs and performance tuning.
• Backup, restoration and recovery in different scenario.
• Monitoring the CPU usage, IO statistics and memory usage to identify any OS level performance killers.
• Managing user creations, assigning roles to SQL Databases.
• Server side and client side DB trace to monitor the activities on the database server.
• Capacity planning for new servers.

Environment: SQL Server 2000, ERwin, DTS, SQL, TSQL, Windows

Confidential

SQL Server DBA

• Wrote stored procedures in SQL Server Using TSQL.
• Performance tuning. Database backup and restore.
• SQL 2000 log shipping and replication.
• Installation of components in MTS.

Environment: SQL Server 2000, ASP, VB, COM, MTS, Windows

Confidential

SQL Server 2000 - DBA

• Wrote stored procedures in SQL 2000. The procedures are referred by front-end applications to enter or display the data to the users.
• Performed DBA related activities such as database creation, backup\restore.
• Creation of test data for test tools. Creation\modification of ERwin diagram for data modeling.
• Creation of deployment guide and master tables scripts to run on clients server, which is presented to the user at the end of project.

Environment: SQL Server 2000, SQL, TSQL, ERwin, Lotus Notes R5, Windows

Confidential

SQL Server DBA

• Delivered change requests send by client.
• Involved in modifying/creating procedures at backend SQL server.
• Maintenance of SQL database servers (backup/restore/maintenance job execution.
• Knowledge transfer. Knowledge management activities.

Environment: SQL Server 7.0, SQL, TSQL, Visual Basic 6.0, Active Server Pages, Power Builder 5.0

Confidential

SQL Server DBA

• Wrote stored procedures in SQL server 2000/7.0.
• Registered COM components on MTS.
• Used Flash for design of website.
• Modified COM components.
• Used Visual Source Safe for version control.

Environment: SQL Server 2000/7.0, ASP, VB 6.0, COM, IIS, MTS