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 noledge 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 wif 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 wif the same. Applied Hot fixes and Service Packs in clustering environments
• Setup Database Mirroring in High Performance and High Availability mode and troubleshooted issues wif 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)
• Experience wif data transfer from oracle database to Sql Server database using SSIS packages
• Good experience wif Oracle 11g/10g databases in activities such as creating and managing db objects like tables, view and indexes. Managing security and monitoring of databases using Enterprise Manager
• Proficient wif SQL Server 2005/2008Reporting Services, Analysis Services
• Experienced in developing drill down reports, drill through reports using SQL Server Reporting Services and Crystal Reports
• Worked closely wif 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 wif self-motivation, initiative and the ability to think outside the box
• Experience working in24 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

Sr SQL Server Database Administrator

Responsibilities:

• Preparing Data Models for 18 applications and support application team on data base related issues.
• Preparing documentation on database details like tables, views, store procedures, functions and column data types.
• Documenting and preparing the database diagrams for developers
• Involved in noledge transfer on Bayer and CDW projects
• Working on 18 applications databases of QA and Dev to assist application team for development.
• 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
• 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

Confidential, Plano, TX

Sr. SQL Server Performance Analyst/ DBA

Responsibilities:

• Installed SQL Server 2008R2 on Windows 2008R2 and migrated SSIS packages
• Creation of SQL Logins, Roles and assigning Permissions as part of established security policies via ACTIVE DIRECTORY
• Migration of databases from SQL Server 2005 to SQL Server 2008R2 And also SQL Server 2012
• Expertise in running Load Tests using WAPT Tool, and capturing Long Running Queries in the Profiler and fine tuning the Stored Procedures and other Adhoc SQL
• Constantly monitored performance of critical servers and improved performance wherever possible of several tsql queries using execution plans, and applying query hints and index tuning
• Experience in analyzing query plans, writing stored procedures, try-catch blocks, using extended stored procedures, managing indexes and locks, troubleshooting deadlocks and blocking
• Checking the database consistency wif DBCC commands at regular intervals, managed disk space and memory and user connections and monitored SQL Server performance using profiler to find performance bottlenecks
• Implementing database maintenance plans that consisted tasks such as update statistics, re-indexing, rebuilding the indexes at regular intervals for better performance
• Performed horizontal data partitioning for efficient management of database tables and indexes, and tuning LOB, BLOB data types
• Installed SQL Server 2012 and configured Always On wif primary and secondary replicas
• Working on different environments and has been a key resource for deployment of any database change requests to production environments
• Designed and deployed SQL Server Integration Services (SSIS) Packages, wif error handling, environmental and SQL Server package configurations
• Created dynamic SSIS packages to load data into stage tables from flat files
• Created SSIS/DTS packages for finance application that would transfer data among servers and performed various data transformations and scheduled the same SSIS packages by creating the corresponding job tasks
• Migrated data from Oracle database to Sql Server database using SSIS packages
• Making Oracle 11g database backups and performing recovery using RMAN utility tool
• Created and managed Oracle 11g schema objects, such as tables, indexes, and views
• Experience wif creating and managing Oracle 11g user security objects
• Proactively monitored the database's health and took preventive or corrective actions as required using Oracle 11g Enterprise Manager
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained referential Integrity
• Configured and managed virtual servers and worked on virtualization of SQL Servers
• Designed and implemented comprehensive backup and recovery plans
• Created db master keys, symmetric keys, asymmetric keys, s for column-level encryption
• Technical Analysis, Code Review, Implementation, 24 x 7 production 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
• Generated Reports using Global Variables, Expressions and Functions for the reports
• Maintained SQL Scripts for creation of Database Objects

Confidential

SQL Server DBA/ Developer

Responsibilities:

• Involved in Migration of SQL Server and also on new hardware wif 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 wif 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
• 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
• Worked on call 24/7 Support on weekly basis

Confidential

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 wif 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 wif 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 wif 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
• 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

Jr. SQL Server DBA

Responsibilities:

• Performed regular Database Maintenance task, Checking the disk Defrag procedures in Development environment
• Involved in Installation of SQL Server wif Multiple instances, Service packs and Hot Fixes
• Assisted in Setup and troubleshooting Active/Passive Clustering for SQL Server2005
• Configured Disaster Recovery solution using Log Shipping. Setup for Snapshot and Transactional Replication between Servers, troubleshoot and monitor Publishers, Distributors, and Subscribers
• Used Index Tuning Advisor for Database performance for proper indexes
• Involved in upgrading of existing Servers from SQL Server 2000 to SQL Server 2005
• Implementing Load balancing Replication across the Databases
• Performed Database Refresh tasks from production to Development and Staging Servers
• Involved in Performance Tuning of the SQL Server for Web based Production and Development environments
• Used PerfMon and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Performed Uploading of bulk data migration wif BCP Utilities
• Performed Database consistency checks wif DBCC, Defrag, Index tuning and monitored