SUMMARY

• 9+ years of IT experience as SQL Server Database Administrator
• Performed Normalization and built Referential Integrity Constraints
• Experience in Installing and Configuring SQL Servers (2012/2008R 2/2008/2005/2000 )
• Expertise in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases
• Expert in SQL Server 2008 features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE)
• Expertise in using Ticketing system software HEAT and BMC to track any issues
• Extensive knowledge and experience in developing Stored Procedures, Views, Triggers, Cursors and Complex Queries on SQL Servers (2000/2005/2008/2008 R2/2012)
• Experience in maintaining SQL Server Security, performed many tasks such as creation of logins and users, configuring permissions and assigning roles to database users
• Created and maintained Jobs and Schedules, Alerts, Notifications for system errors, insufficient resources, fatal database errors, hardware errors, security etc.
• Experience in creating packages, jobs, sending alerts using SQL Mail
• Experience in data migration from Access/Excel Sheets using import/export and BCP utilities
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities
• Extensively Monitored Performance with multiple tools like Performance Monitor, SQL Profiler, Event Viewer, IDERA Diagnostic Manager, Index Tuning Wizard, and Database Tuning Wizard to achieve better performance, Resolved Deadlocks, optimized Long Running Queries, ensured accessibility and efficiency
• Experience in creating and scheduling Backup and Restore Jobs, Log Shipping and other Maintenance plans using Native & Third - party tools (LiteSpeed5.0 and Red Gate SQL Backup)
• Extensive experience in Configuration, Implementation and Maintenance of all available SQL Server HADR solutions like Clustering, Database Mirroring, Replication and Log Shipping
• Involved in implementation of multiple multi-node clustered community environments, which supported multiple instances of SQL Server 2005 and later
• Actively involved in setting up of Active-Active/Active-Passive clustering in production and Testing Environments and also troubleshooted issues with the same. Applied Hotfixes and Service Packs in clustering environments
• Setup Database Mirroring in High Performance and High Availability mode and troubleshooted issues with the same
• Experience in Installation, Configuration and Administration of SQL Server Integration Service. Created (SSIS) packages for data migration and redesigning SQL Server 2000 DTS Package into SQL Server 2005 SSIS (ETL)
• Proficient with SQL Server 2005/2008 Reporting Services, Analysis Services
• Experienced in developing drill down reports, drill through reports using SQL Server Reporting Services and Crystal Reports
• Industry working experience in SQL Server and Oracle database management, maintenance, and troubleshooting
• Worked closely with project management, application development and testing teams, and also end users on various projects to offer database solutions to resolve varied business problems
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box
• Experience working in 24 x 7 On-Call environments

TECHNICAL SKILLS

Databases: MS-SQL Server 2000/2005/2008/2012 , Oracle, MS Access

Languages: C, C+, T-SQL, VB Script, Java Script, HTML, XML

SQL Server Tools: Management Studio, Enterprise Manager, Index Tuning Wizard, Idera Diagnostic Manager, Spotlight, Foglight, Database Tuning Wizard, Profiler, Query Analyzer, Export & Import, Precise i3 for SQL Server

Operating system: Windows / 2003/ 2000/ Professional/ NT 4.0 Advanced Server

OLAP Tools: SQL Server Analysis Server 2008, 2005, SSIS (as ETL), SSRS

Load Test Tools.: WAPT, WAPT Pro

PROFESSIONAL EXPERIENCE

Confidential, Kansas

Sr SQL Server Administrator

Responsibilities:

• Involved in setting up, maintaining and supporting high availability concepts like Clustering, Mirroring, Replication and log shipping
• Experience in installation of SQL Server 2008 R2 and SQL Server 2012 in newer environments
• Experience in applying latest Service Packs for 2008, 2008 R2 and 2012 Sql Servers
• Experience in working on both VMWare and Standalone physical servers
• Involved in troubleshooting performance issues like Memory Pressure, High CPU Utilization and Disk IO throughput issues at SQL Server level
• Extensive experience in setting replication, mirroring and log shipping
• Involved in Capacity Planning, data modeling and Logical/Physical database Designs
• Daily task to verify the backup jobs and maintenance jobs and to check their successful completion
• Worked on space reports for all servers and request the space if it is required, to maintain below 70% of space occupied
• Experience in generating the reports and running scripts using central management servers
• Worked on setting up the multi-server administration to manage target servers from a centralized server
• Scheduled the Maintenance jobs, Native backup jobs and “shrink transactional log file” jobs from Multi-Server Jobs
• Assign Service-now tickets and complete the work as requested
• Experience in handling multiple internal projects at a time and implemented them successfully
• Worked on Critical Business requirements to execute SQL scripts on Production servers using emergency change request
• Involved in User requested tickets to execute the scripts both DML and DDL operations on UAT and Production environment
• Worked on privilege tickets to provide read, write and execute permissions on windows and SQL Logins
• Experience in decommissioning the old servers and databases which are not required using service-now tickets, also filling up the decommissioning request form
• Worked on requesting Firewall ports to be open to connect SQL Server machines
• Extensive experience in Idera backup tool which has policy based schedules
• Involved in monitoring the SQL Server performance issues using third party tools like Foglight and Performance Analysis
• Also have experience in using performance dashboard reports in SQL Server
• Experience in supporting DR servers to confirm that servers are functioning properly
• 24/7 on call support

Confidential, Tx

Sr. SQL Server DBA

Responsibilities:

• Installing, Configuring and Administering SQL server 2012, 2008R2
• Developed backup strategies for Database Recovery
• Performing database maintenance activities like Backups, Restoring
• As a part of the DBA team providing 24/7 production support to the clients
• Creating and Monitoring the Scheduled jobs
• Implemented and maintaining Log shipping, Replication, Mirroring High-Availability options
• Configured and administered SQL Clusters (Active/Passive, Active/Active)
• Experience in understanding structured data analysis, data models and data normalization
• Good experience in resolving blocking/locking and deadlocks Issues
• Verifying Index Fragmentation and performing re-org and rebuild as per %
• Troubleshooting Log Shipping and Database Mirroring and the failed jobs
• Worked on migration from SQL 2005 to SQL 2012/2008R2 including databases, logins, users, jobs, and also DTS packages
• Deployed databases in virtual environment
• Worked on setting up backup jobs for OLAP databases
• Monitored and resolved Log Shipping out of sync issues
• Created and managed maintenance jobs for performing SQL Backups, DBCC, and Index creation/recreation
• Performing daily tasks like Backup & DBCC job verifications and check in failures
• Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine tuning of Database Application.
• Experience in maintaining SQL Server Security, creation of logins and users, configuring permissions and assigning roles to users
• Configured database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions
• Verifying all error log files for any new entries
• Created Jobs, Alerts and scheduled DTS Packages and SSRS to generate reports
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure optimal performance of the server
• Developed, implemented, and maintained policies and procedures for ensuring the security and integrity of SQL Server 2005, 2008 and 2012 databases
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes
• Data Migration (transformations) from DB2 & Oracle to SQL Server 2012/2008 using SSIS, BCP and Import/export tools
• Used SQL*Plus to communicate with Oracle Servers and deploy scripts
• Generated Reports using Global Variables, Expressions and Functions for the reports
• Maintained SQL Scripts for creation of Database Objects
• Developed many adhoc t-sql scripts, stored procedures and functions using ANSI SQL

Confidential, Memphis TN

SQL Server DBA/ Developer

Responsibilities:

• Involved in Migration of SQL Server and also on new hardware with the platform of Windows 2000 and 2003
• Collaborate on configuration of servers to support a variety of business applications, data warehouse infrastructure, database platforms, COTS, open source, custom developed and web applications
• Oversee backup, clustering, mirroring, replication and failover
• Configuring and Troubleshooting Service Objects in Service Broker for moving the Message queue in Database and Instance Level
• Install and validating the upgrades and patches
• Configuring and Troubleshooting Disaster and High availability solutions of Mirroring, Log shipping, Replication and Clustering
• Working with third party tools Quest Lite Speed for log shipping and Fog light for performance monitoring
• Support team to ensure process compliance for Quality and HIPAA/FFIEC Regulations
• Performed application program enhancements, troubleshooting and bug fixes as required
• Migrated DTS packages to SSIS (SQL Server Integration Services) using DTS migration wizard
• Management of users including creation/alteration, grant of system/db roles and permissions on various database objects
• Developed standards and guidelines to develop, maintain and administer the SQL Server database
• Monitoring the server for High availability of the servers solving the raised by user support
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages
• Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures
• Handled Database recovery (disaster recovery), diagnosed, repaired and was involved to transfer the OLTP data to Data Warehouse
• Development of T-SQL Stored Procedures for Export & Import of data from databases and Transaction Databases of different agencies
• For transferring, used data import and Export utility and BCP command line utility
• Automated messaging services on server failures, for task completion and success
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers
• Performed query tuning & optimization using Query Plans & SQL Profiler
• Experience in Oracle database management and also setting up RMAN backups
• Experience writing SQL * Plus scripts and using TOAD to develop procedures and functions
• Implementing different Development and Test Server instances for the Application Development Team and to co-ordinate Development and Testing Environments and keep them updated
• Creation and maintenance of databases, creating roles and managing user permissions
• Developed many adhoc t-sql scripts, stored procedures and functions using ANSI SQL
• Worked on call 24/7 Support on weekly basis

Confidential, Englewood, CO

SQL Server DBA

Responsibilities:

• Involved in Installation and Maintenance of SQL Server 2005 and 2008 R2 on Development, UAT and Production Environments
• Maintaining SQL Server 2008R2/20 bit) on Active/ Passive Cluster with latest Service Packs, Hot Fixes
• Monitoring and making recommendations for performance improvement in hosted databases
• This involved index creation, index modification, code optimization and adding scheduled jobs to re-index and update statistics in databases
• Providing production support to the users
• Maintain the integrity, availability, and recoverability of all production data systems. Planning for overall data deployment and operational health
• Setup database HA environment (Replication, Log Shipping) & supported Application DR test
• Responsible and Involved in SQL Server Performance Monitoring, Server and Database optimization and Query tuning
• Analyzed database performance with SQL Profiler and Perfmon Optimized indexes to significantly improve queries
• Troubleshooting, Debugging and Performance Optimization for SQL Server Database and Application Related issues
• Conducting Database Refresh once in every week from PROD to UAT, DEV, and Test Environments
• Monitoring SQL server Error logs, Disk Space growth, Clustering Environment
• Planning and applying latest Service Packs to different versions of SQL Server
• Worked on performance and tuning, identifying locking and blocking for long running queries
• Monitoring clients' application and escalating code bugs to development team. Supports Production, UAT, and Development Environment
• Implemented the Security Best Practices for Databases using the Policy Based Management in SQL Server 2008
• Worked with Backup Compression, Policy-based management, Resource Governor, SQL Server Audit
• Involved in the design of new schema, new tables, field definitions and mappings, stored procedures, views, indexes/key and SSIS Configuration Scripts
• Updated the existing stored procedures to eliminate cross server joins
• Involved in cleaning up and archive the redundant data from production server
• Maintained the table performance by following the tuning tips like normalization, creating Indexes
• Created Views as per the technical design
• Involved in developing ad-hoc queries
• Involved in Upgrading DTS packages to SSIS. Creating flowcharts for DTS packages for review
• Generated Complex reports like reports using Cascading parameters, Snapshot reports Drill- down Reports, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on Business Requirement Document
• Developed many adhoc t-sql scripts, stored procedures and functions using ANSI SQL
• Used SQL*Plus to communicate with Oracle Servers and deploy scripts
• Involved in Data Modeling for the applications and creation of ER diagrams using ERWIN and MS Visio
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2005

Confidential

SQL Server Developer

Responsibilities:

• Installation and configuration of MS SQL Server 2005/2000
• Created Stored Procedures, User defined functions, Views and Wrote T-SQL code maintaining query standards for the project
• Created ER diagrams
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables, and worked on inline Sql Queries and Stored Procedures Tuning
• Involved in normalization of database and tables and their optimization
• Involved in conceptual and physical modeling of data using ERWin tool
• Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL)
• Part of team for analyzing and implementing the physical design for database
• Writing complex Stored Procedures to meet the business requirements
• Designing logical and physical database structure for agile projects
• Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000
• Designing and building data load procedures, using MS SQL Server
• Wrote DTS ActiveX scripts that extract data from database tables and write the data to flat files
• Responsible for transferring of database and database objects from Development to Production Server using DTS
• Used SQL Profiler and Query Execution Plans to optimize DTS package queries and Stored Procedures