SUMMARY:

• 14+ years’ experience as Production SQL Server DBA, consultant and Architect in number of DBMS accounts and mission critical projects.
• Proven ability to provide on demand support to Microsoft SQL Server 2012, 2008 (+R2), 2005, 2000, 7.0 & 6.5 version database servers for maximum performance.
• Self - motivated quick learner, strong analytical and problem solving skills.
• Capable of working under pressure and mission critical environment;
• Effective communication & people management skill in geographically separated virtual team & offshore work management.
• A good team player who can be flexible and work individually
• SQL Server 2014/2012/2008 (R2)/2005/7.0 Database Administration (DBA) for Very Large OLTP Environment
• SQL Server Consolidation & Virtualization | Server Migrations | Data Center Migrations, Cloud Transition
• SQL Server Production Database Support, Deployment, On Call support & Troubleshooting
• SQL Server Performance tuning, Identifying Bottleneck, SQL profiler, Query Execution plan and 3rd Party tools
• Implement Always On, DB Mirroring, Clustering, Replication, Log Shipping, Partitioning, HADR Solutions
• Server Capacity Planning, sizing, Hardening, performance reports & Best Practice Implementation
• SQL Server Disaster Recovery Setup and Business Continuity Planning & Implementation
• OLAP Cube Design, Deployment, Logging, Monitoring and Optimizing Analysis Services Solutions
• Designing & Deploy Report (SSRS), Shared Data sources, permissions, performance report Caching, Snapshots
• Troubleshooting, Design, Deploy and Optimizing SSIS package performance

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

SQL Server DBA | Database Consultant

Responsibilities:

• SQL Server production database support & Troubleshooting SQL Server 7.0, 2000, 2005, 2008(R2), 2012 versions. Supporting high volume OLTP databases over 2TB; & OLAP 5TB
• SQL Server services Installation, applying Service pack and Patches/updates to fix bugs
• Installation & maintenance of SQL Clustering (active-passive, active-active, multi node)
• Creating and maintaining Always On availability groups (HADR/ Replica)
• Configuring Database Mirroring, sync & asynchronous with monitor
• Setting up Log Shipping with custom backup & onsite/offsite/ftp restore schedule
• Setting up SQL Replication (transactional, merge, snapshot, Peer to Peer transactional)
• Design and Implement SQL Server Resource Governor for limiting & managing system workload, prioritizing users/groups
• Administer large number of SQL Servers by using Policy-Based Management, designed & applied custom policies
• Experienced in creating Server/Database level SQL Auditing (DDL trigger) Change Data Capture
• Created custom DBA script using DMVs, system tables for database management
• Using SQL Server dashboard reports, DMVs and Profiler to identify slow or hardware resource consuming T-SQL queries
• Using Performance Data Collector, windows perfmon and 3rd party tool to identify system hardware usage and bottleneck
• Capacity planning for new systems & growth planning for existing SQL Servers
• Benchmarking SQL Server hardware requirements, CPU, Memory, SQL Cache, Disk IO, RAID
• Created Table & Index Partitioning function/scheme for scalability and easier data manageability
• Evaluating and applying SQL Data compression - Row, Page level
• Securing data using Encryption- Transparent data encryption (TDE), Cryptographic function, Key, Certificate
• Designing database Backup & Recovery policy as per RPO and RTO
• Created & managed Database Role, login, user Security, Proxy, objet level db permissions
• Setup custom Database maintenance plan, DBCC, update statistics, Integrity Check, trace flags
• Identify unused indexes; create missing indexes and regular reorg/rebuild Index maintenance
• Evaluating Database Locking Architect, Diagnosing and Resolving Deadlocks, blocking, Latch
• Developed & maintained scripts, utility jobs or implement needed software for database maintenance.
• SQL Server Consolidation & Virtualization | Server Migrations | Data Center Migrations, Cloud Transition
• Creating & Deploying new Microsoft Azure Subscriptions, Server Sizing, Stripping Storage Volumes to get best IOPS, moving Storage, VHDs from one account to other accounts, database maintenance, blob url backups.
• Best Practices implementations for Azure environments.
• Setting up High availability | DR solutions over Azure, setting up Availability Groups for multiple GEO locations

Application/ Development DBA

Confidential

Responsibilities:

• Extensively worked on T-SQL Performance Tuning (query execution plan) applying 80-20% Rule
• Optimizing and Reviewing T-SQL Changes, SQL code deployment, to & from QA, Test, Staging, Archive, data warehouse & Production servers
• Designing Relational Database objects (SP, function, view, Trigger, Table, Index, Data Type, etc)
• Created Linked Servers, odbc connections for Data transfer between SQL Server and other heterogeneous relational databases
• Creation of Jobs, Schedules, Alerts, Operators using SQL Server Agent and custom notifications using SQL/ Database Mail, email to text
• Experienced in ETL, Data Cleansing, Create & deploy SSIS Packages, DTS to SSIS Migration
• Experienced in creating Analysis Services cubes (MOLAP, ROLAP, HOLAP, MDX Query), SSRS Reports, Data Mart, Data Mining, Dashboard reports & Charts.
• Worked on OLAP db designing, star and snowflake schemas, fact tbl, dimensions and Measures
• Designed & Architect BI Data warehouse from scratch for Enterprise class applications
• Closely worked with development team to assist them in various problems solving and troubleshooting applications

Project DBA

Confidential

Responsibilities:

• Enterprise Level SQL Server Consolidation & Virtualization using VMware, HyperV
• SQL Server instances and entire datacenter site migration, planning & execution
• SQL Server upgrades to higher versions from ~ 7.0/2000/2005/2005/2008 (side by side, in place)
• Database Security Audit, Data Retention, HIPPA, SOX Compliance, PCI Data Security Standard
• Database table/index size analysis for db space reduction using various constructive
• Defining databases support SLA, Contracts and guidelines for SQL & Application Servers
• Representing in weekly operations call & meeting with Service Delivery management, reporting SLA target, issue, single point of contact for DBMS Team, 24*7 escalation
• Managing geographically separated team & mentoring, Customer and Vendor Relationship
• Reviewing, Assigning & following up on Incident, Change management and Request tickets based on Service level agreement and Criticality
• Experienced in Day to day DBA operations and geographically separated Team management
• Creating daily DBA team shift roaster and 24*7 On call rotation schedule
• Creating SQL DBA best practices & enforcing guidelines across teams
• Creating and implementing data security, user right assessment, patching policy for various sites
• Creating & testing database business continuing and Disaster Recovery Setup for mission critical applications & database servers
• SQL Server backup using LiteSpeed Idera SQL Safe backup, Red-Gate SQL backup pro v7, NetVault
• Configured enterprise level Backup policy using IBM TSM Tivoli, Symantec CommVault, EMC Legato Networker
• Configured SQL Server Monitoring using Red-Gate SQL Monitor, Quest Foglight (SpotLight for Enterprise level), Performance Analyzer (PA), Idera Tools
• Configured Enterprise level SQL Server Monitoring, alerts and warning using BMC PATROL, and NetIQ AppManager
• Custom high availability/ Disaster recovery using SAN to SAN replication for VLDB databases
• Experienced in BMC Remedy, CA Service Desk tools, ITIL V3 certified
• Experienced in creating Powershell scripts for SQL Server
• Worked with various 3rd party SQL software for maintaining Code Changes, Ticketing system

Environment: Microsoft SQL Server 7.0, 2000, 2005, 2008, 2012, AZURE; hosted on Windows Operating System

Confidential

Database Administrator | Architect

Responsibilities:

• Drives continuous DB improvement initiatives to increase efficiency, availability, productivity and security.
• Production 24*7*365 Support, Optimizing Database design, Stored procedure, triggers, function, Indexes, Auditing and Archiving
• Design database solutions to satisfy application (business and technical) requirements
• Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems, such as the installation of new databases.
• Develop custom utilities to automate recurring operational activities

Environment: SQL Server 2005 and Window Server

Confidential

Database Service Manager | Architect

Responsibilities:

• Experienced in providing production, operational support services for database systems within a complex Enterprise IT Infrastructure. SQL DBA Production Support & Troubleshooting (24*7*365)
• SQL Performance Tuning, SQL Clustering, Log Shipping, SQL DB Mirroring & SQL Replication.
• Optimizing Database design, Stored procedure, triggers, function, Indexes, Auditing and Archiving
• Designing SSIS Packages, DTS Migration, SSRS Reports and Analysis Services
• Review T-SQL Changes, database designs and SQL code deployment on QA/Test/Staging/Production

Environment: SQL Server 7.0, 2000, 2005

Confidential

Technical Specialist | SQL Database DBA

Responsibilities:

• Planning, Installation, management, administration, monitoring, optimization and supporting Microsoft SQL 2005, 2000, 7.0, Databases on VLDB environment
• SQL Replication, Log Shipping, SQL Clustering (Installation/Maintenance)
• Finding & Tuning SQL Server hardware bottlenecks, Production Database Support (24*7*365). Performance tuning using SQL profiler, Execution plan, Performance Monitor
• Installing & Configuring SQL Server Analysis Services on clustered environment
• Security Auditing, Server Hardening, DDL Triggers | SQL Server Profiler | Event Notifications
• Backups, Database restore, Server Migrations, Database Consolidations.

Environment: SQL Server

Confidential

Technical Specialist | Associate Manager

Responsibilities:

• Setting up Server & Storage hardware benchmarking for new DB Servers & Projects
• SQL Server Production DBA Support, Windows Administration
• Involved in the development of custom applications in various internal processes of the company with Visual Basic, ASP, HTML front-end and SQL Server as backend.
• Setting new Servers Hardware specifications to meets application requirements. HP Proliant Servers
• Manage Windows | Desktop team to support overall IT segment.
• Involved in defining, measuring, analyzing, improving and controlling the database server and frontend application management processes.

Environment: SQL Server, Windows Server, SAP CRM

Confidential

Database Consultant

Responsibilities:

• Install, Implement, support Database Administration | Production support for SQL database servers.
• Security Audit, Stress Testing and Growth Planning of SQL databases.
• Business Continuity planning and Disaster Recovery Implementation
• Review T-SQL Changes, database designs and SQL code deployment on QA/Test/Staging/Production.
• Production database support for SQL 7.0; 2000; 2005
• Implementing SQL Clustering, Log Shipping, SQL Database Mirroring, SQL Replication
• Backup/Restore & Disaster Recovery Setup
• Providing support to high severity SQL incidents.

Environment: SQL Server 2000 hosted on Windows Server

Confidential

Trainee | System Administrator

Responsibilities:

• Creating Databases, database objects, Schemas, writing queries, Migration data from fox pro to SQL Server, Database Administration
• Implementation and Administrator Windows Servers, Assign Permissions and Performance optimization.
• Data Modeling, Database Schema development including table, Index, stored procedures, functions creations for Database Systems.
• Creating, Managing & Optimizing Performance for Views, Procedure, Triggers, CLR Objects, Table, Functions
• Query Performance Optimization - Execution Plans, Exception Handling

Environment: SQL Server, Window Terminal Server, Fox PRO, Visual Studio, Windows 98, Windows 2000