SUMMARY

• SQL Server Database Administrator with 14+ years of experience and proven track record of designing, administering and supporting database systems.
• Expertise experience in Installation, Configuration, and Management of SQL Server |2012|2008|2005|2000|7|6.5 database servers on multi node multisite SQL clusters.
• Experienced with Implementing and Maintaining IT solutions for a large inventory of SQL Servers using technologies such as Log Shipping | Database| Clustering | Mirroring | Always On HADR.
• Expertise Experience in Provisioning and Configuring Servers and Databases in Microsoft Azure Platform as Service (PaaS) and Microsoft Azure Infrastructure as Service (IaaS).
• Expertise experience in Performance Tuning using Execution plan | Profiler| Performance Monitor| Extended Events| Data Collector | Resource Governor| DMV’s |DMF’s |PSS diag.
• Implemented new SQL Server 2012 mechanisms like data compressions | online indexing | Contained Databases | security principals | AAG | Partitioning (Horizontal).
• Experience in encryption strategies such as Transparent Data Encryption (TDE).
• Expertise Experience in building complex SSIS and DTS packages using Business Intelligence Development Studio. Experience with BCP and Bulk Insert.
• Expertise in TSQL writing stored procedures, triggers and functions.
• Technical lead in charge of migration over 150 databases from SQL to SQL |2012.
• SQL Server Virtualization & Consolidation on VMware and Hyper - V environments.
• Solid IT infrastructure foundation and skilled in automation, scripting, security and database development.
• Experience with Very Large Databases (VLDB’s) ranging from 1 terabyte to 12 terabytes with 25000+ transactions an hour.
• SQL Server Hardening & Best Practice Implementation as recommended by Microsoft.
• More than 12 + years of experience in administration of Windows | including Windows Failover clustering, Active Directory, DNS and DHCP.
• Vast experience with Monitoring tools like Microsoft Operations Manager (MOM), System Center Operations Manager (SCOM), Idera, SQL Spotlight and SQL Sentry Plan Explorer.
• Experience with building SCOM management packs to monitor various SQL Server Performance counters, deadlocks, and locks in SCOM .
• Experience in Web server (IIS 7.0 |6.0 | 5.0) installation/configuration, troubleshooting IIS issues. Experience in building IIS websites.
• Experience in Troubleshooting ASP and.net applications hosted on IIS.
• Experience in installation, configuration, and administration of Team Foundation Server |2013 and troubleshooting issues.
• Experience with Storage Area Networks (SAN: CX300 | CX310 |CX340).
• Experience with on-call problem resolution and triage in SQL Server environments.
• Experience in planning, designing, and documentation of disaster recovery plan.
• Experience in working with geographically dispersed team and teams such as Infrastructure, Storage, Networking, Development and QA.
• Certified Microsoft Solutions Expert in Data Platform.
• Certified Microsoft Solutions Associate in SQL Server 2012.
• Certified Microsoft Azure Solutions Architect

TECHNICAL SKILLS

Relational Databases: SQL Server 2016/2014/ 2012/ 2008/2005/2000 /7.0/6.5, MySQL, and DB2

Operating System: Windows 2016/2012/20 bit & 32 bit)

Database Administration Tools: SQL Server Management Studio, Enterprise Manager, SQL Profiler, Control - M, Microsoft Visual Studio, Business Intelligence Development Studio.

Query/Reporting: SQL Query Analyzer, MS SQL Reporting Services 2012/ 2008/2005/2000, and Crystal Reports.

Database Monitoring Tools: SCOM 2012/2010, Idera, Redgate, Spotlight on SQL Server, Cacti, NT Performance monitor, SQL Profiler, and SQL Sentry Plan explorer.

Database Maintenance Tools: SQL Lite Speed, CA.

Data Model Tool: ERWIN, Visio

Web Server: IIS 5.0/6.0/7.0

Programming Languages: T-SQL, ASP, C++, HTML, DHTML, Shell Scripting, PowerShell

Certifications: MCSD, MCSE, MCSA, and MCP. Microsoft Certification ID 11693529

PROFESSIONAL EXPERIENCE

Confidential

Senior SQL Database Architect

Responsibilities:

• Architect, Design, Install, Configure, Optimize and Manage complex enterprise-wide SQL Server 2016, 2014, 2012, and 2008 instances on multisite multi node windows clusters.
• Responsible for providing 24x7 critical Production Support to all 2000+ Production, Development and Clustered servers.
• Installed, Configured and Maintained high available solutions such as Always-on, Database Mirroring, Replication, and Log Shipping.
• Worked extensively on configuring and troubleshooting Always-on on SQL 2012/2014.
• Responsible for OLTP Design (logical/physical), development, implementation, and maintenance phases.
• Responsible for OLTP Code and design review. Ensure database security, integrity and performance.
• Provided production and development support of Microsoft Azure SQL PaaS and IaaS.
• Created and managed SQL Server Azure Databases. Setup SQL Azure Firewall. Setting up connection strings and connecting SQL Server Azure Databases from locally installed SQL Server Management Studio (SSMS) for development staff.
• Maintained mission critical Enterprise Confidential applications such as Auto and Cycle new business.
• Installed and configured SQL Server Integration services in SQL 2012. Created, deployed, configured and monitored complex ETL/SSIS packages on clustered and always on environments.
• Coordinated patch management of windows OS and clusters .Tested and applied latest service packs and cumulative Hotfix which addressed specific issues for SQL 2012/2008 and Windows 2008/2012.
• Administration of System Center Operation Manager 2012/2007. Responsible for creating and managing capacity and performance charts to capture monthly baseline performance reports.
• Responsible for creating, testing and deploying custom SCOM monitors and management packs in SCOM 2007 and SCOM 2012. Troubleshoot misconfigured or malfunctioning monitoring.
• Troubleshoot Operations Manager Infrastructure issues and agent provisioning/de-provisioning. Implementing new features and deployment of SCOM 2012 - SQL management pack is desired.
• Installation, configuration, deployment and scheduling of SQL Reporting Services.
• Implemented Transparent Data Encryption on level one database which contains sensitive customer information.
• Assisted in the planning, design, and documentation of disaster recovery plan.
• Responsible for proactively monitoring databases and optimize systems for better performance.
• Performance tuning - Identify SQL bottleneck queries and tune the queries for optimal performance using DMV’s, DMF’s, xtended events and pssdiag.
• Resolved locking conflicts/blocking and resource utilization. Worked with database developers and engineers to analyze database performance and identify problems in areas such as: execution plans, index coverage, and SQL server statistics. Resolve complex database administration problems.
• Configured SQL Server Audit to track changes to SQL job and to track DDL changes.
• Involved in complete Life Cycle experience in DB projects including Business Needs Analysis, Technology Selection, Capacity Planning, Design, Installation & Development, Maintenance & upgrades.
• Adhered to strict Microsoft standards set for clustering, always-on, local security policy etc.
• Responsible for migration of databases from an unsecured domain to secured domain.
• Automation using PowerShell scripts, system tables and DMVs.
• Topology and capacity planning including Windows and SQL Server clusters nodes and SQL Server instances, CPU, RAM speed and quantity, local disk configuration.
• Developed strategies for data acquisitions, data recovery, & enterprise level database implementation.
• Worked extensively on configuring third party monitoring tools such as SCOM and Idera.
• Implemented backup solutions using third party tools such as SQL Lite Speed.
• Work with Development, QA, Infrastructure, and Support on capacity planning, scalability, and overall application performance.
• Provided technical and software support to developers and end-users.
• Providing mentoring, guidance and general oversight to less experienced staff in a variety of database design, administration and /or modeling activities.
• Researched and executed production methodologies and documented system.
• Provided on call production database support.

Environment: SQL 2014/2012/2008, Windows 2012/2008, T-SQL, Always-On, SSIS, SSRS, Database Mirroring, Log Shipping, Windows Failover clustering, SQL Azure PaaS/IaaS, SCOM 2007/2012, Idera.

Confidential

SQL Database Analyst

Responsibilities:

• Production support, Performance Tuning, BCP/DR, Dev Support.
• Production database support to Confidential Business Payroll solutions.
• Performance tuning and deadlock analysis.
• Development support and BCP (Business continuity) using database mirroring and log shipping.
• Managed DDL and DML changes through the SDLC
• Providing design, development, and testing support to assigned brokerage application teams.
• Managed on-call problem resolution and triage for the production SQL Server database environment.
• Installing SQL Server products; manage patching and compliance issues.
• Analyzing performance issues and providing recommendations based on testing results or problems being experienced in production.
• Maintaining SQL Replication between source and target SQL Server databases.
• Leading the planning, analysis, design, implementation, maintenance, and control of the organization’s server-class databases.
• Consulting with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction.
• Handling and leading various large-scale or highly complex data/database management activities including one or more of the following: designing highly complex logical and/or physical databases; leading highly complex data modeling, mapping, integration, and capacity planning efforts; developing management policies, procedures and standards; and business requirements identification, analysis and development.
• Using third party tools like Spotlight, SCOM and SQL Sentry plan explorer to monitor and analyze performance issues.
• Partitioning SQL Server Production and Development tables based on retention rules defined by business.
• Automated a process to start server side trace to capture events for troubleshooting purpose.
• Refreshing pre-production environment with production data. Scrambling sensitive data fields. Setting up SQL Server Broker. Setting up local and remote routes between instances.

Environment: SQL Server 2008/2005/2000, Windows 2008/2003, SSIS, SSRS, SQL Profiler, SQL Server Trace, T-SQL, Perfmon, Mirroring, Log Shipping, Transactional/Merge Replication, SCOM 2007, Spotlight.

Confidential

Enterprise SQL Server DBA

Responsibilities:

• Worked as “Database Administrator” maintaining 35 Production systems (Intranet and internet) responsible for Support, on call 24/7, database maintenance and system maintenance.
• Statewide Automated Child Welfare Information System (SACWIS) support.
• Federal Program Improvement Plan (PIP) Applications Operations and Support.
• Disaster Recovery Planning, testing and implementation for Level 1 applications.
• Data Center migration project: Was part of a team responsible for migration of 240+ servers.
• Technical lead in charge of migrating 150 SQL databases and the applications from SQL 2000 to SQL 2005.
• Installation of SQL 2000/2005/2008 on a clustered (Active/Passive, Active/Active/Passive) and non-clustered environment.
• Technical lead in setting up and maintaining SQL Server log shipping, and Mirroring across geographically dispersed SQL clusters. Experience with setting up replication between homogenous and heterogeneous subscribers such as SQL and DB2.
• Installation, Configuration and support of SQL 2000/2005 Reporting Services and TFS 2008.
• Upgrade experience from SQL 6.5/7.0 to SQL 2005/2008.
• Monitoring, controlling and implementing changes in the production environment.
• Experience in applying Service Packs at database level.
• Monitor Databases in error logs, lock escalation, dead lock, resource utilization by sessions & package caching, buffer pool hit-ratios.
• Involved in Physical designing and development of the application.
• Monitoring the database objects growth, managing the extents growth and de-fragmenting the objects, which are running out of maximum extents. Monitoring the excessive fragmentation of Indexes and taking remedial steps. Configured RAID1 (Mirroring) for OS & Transaction logs. Configured RAID5 for Data files.
• Creation and Maintenance of database, table spaces, users, tables, indexes, stored procedures, roles, profiles, partitions and other schema objects.
• Database loading, Migrating and maintaining data using various utilities DTS, EXPORT, IMPORT and ATTACH/DETTACH Data Migration tools.
• Architected online and tape backup strategy for mission critical applications.
• Performed advanced DBA functions: Physical DB design, linked server definition and security, Day-to-day DBA monitoring and business needs analysis.
• Devised a refresh strategy where in the non- production environment databases is automatically refreshed with production data every day.
• Define enterprise-level standards (coding, architectural, migration), platform and tool selection.
• Performance Tuning using Execution plan, Profiler, and Performance Monitor.
• Created Users and Roles and performed Database Auditing and Security.
• Involved in Migration of Database using Migration Utility. Scheduling of operation and outages.
• Primary Liaison for the applications. DB2 Connect operations and support. MS OLEDB provider for DB2 operations and support.
• Experience with HIPPA data. Experience with backup software such as SQL Lite Speed.
• IIS 5.0/6.0 operations and support.
• 24 X 7 on call Production Support.

Environment: SQL Server 2005/2000/7.0/6.5, Windows 2003/2000, SSIS, DTS, DB2, Replication, Log Shipping, Windows clustering, Cacti, MOM, Redgate.

Confidential

DB Developer

Responsibilities:

• Worked as “DB Developer (Student Assistant)”.
• Installing and Maintaining the SQL Server environment which included creating databases, buffer pools, logical and physical design of database storages, database sizing with proper Log Space and establish securities.
• Upgrade Experience from SQL Server 7.0 to 2000.
• Monitor locking, blocking and resource utilization by package caching, buffer cache hit ratio etc.
• Reviewing proposed strategic changes to production systems. Implementation methodologies and back up strategy.
• Applying OS/Database patches in all the environments.
• Performing various OS tasks like installing/upgrading OS, applying service packs/hot fixes, installing utilities like Anti-Virus.
• Manage and resolve trouble tickets for various database and OS related issues.

Environment: SQL Server 2000/7.0, Window 2000/NT

Confidential

DBA

Responsibilities:

• Developing, configuring and maintaining databases and related systems using SQL 2000.
• Designed and Implemented comprehensive Backup plans and Disaster Recovery strategies.
• Design new table structures and referential relationships.
• Created SQL Server logins and assigning roles and authentication models as part of security policies.
• Created, scheduled and monitored SQL server jobs making sure job run successfully every night.
• Installation of various applications like IIS, Visual Basic and ASP.
• Performing Windows NT administration tasks like OS Installation/Upgrade/patching, NT registry backups, Antivirus installs and updates.
• Learned and applied structured testing application software. Initiated and completed software test automation using Auto Tester.
• Hardware spec design for physical implementation.

Environment: SQL Server 2000, Window 2000/NT.