SUMMARY:

• SQL Server DBA with around 10 Years of experience in Administration 2017/2016/2014/2012, 2008R 2/2008/2005/2000 Database Administration in Production, Test and Development environment.
• Experience in Analysis, Design, Development, Testing and Maintenance, Capacity Planning, Performance support of application systems of OLTP and OLAP databases in the client - server, internet\internet environments.
• Experience in Installing, Upgrading and Migrating databases in and from SQL Server 2016/2014/2012/2008 R 2/2008/2005.
• Expert in RDBMS S/W installation, database server builds, applying patches, Applying patches in VM environments (VTM), upgrading, configuring, trouble shooting of SQL SERVER on Windows 2000/03/08R2/12R2 servers and Clustered VMware Environments.
• Expertise in installing Slipstreams, rolling patches, rolling upgrades in Clustered and standalone Environments.
• Good knowledge on new features Data Compression, Transparent Data Encryption (TDE), Resource Governor, Policy Based Management, Backup Compression and Change data capture in SQL SERVER 2008.
• Expert in Disaster Recovery plans by configuring AlwaysOn, Clustering, Log-shipping, Mirroring and Replication (Snapshot and Transactional).
• Implemented High Availability in SQL 2012/2016 by configuring AlwaysOn Availability groups across Windows Server Failover Clustering.
• Hands on experience in configuring SQL Failover Clustering in Active-Active and Active-Passive nodes.
• Experience in configuring Replication and troubleshooting the issues with transactional replication.
• Very good T-SQL Programming skills. Experience in query optimization and performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Expert in tuning the long running Queries and Store Procedures by examining the execution plans.
• Hands on configuring Temp DB with considerable Memory and Raid Levels for better performance.
• Expertise in using Performance Monitor/Profiler /Activity Monitor to resolve Dead Locks, Long Running Queries and Bottlenecks caused by complex Queries.
• Excellent skills in database Back Up, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing indexes, Defrag Tables, Replication, Linked Servers and Database Maintenance Plan.
• Created Linked Servers between SQL Servers and also to Oracle Databases.
• Good knowledge in using DMVs and DMFs to finding and solving Performance Issue, Data modeling concepts.
• Documented Disaster recovery plans and participated in Disaster Recovery Drills by implementing Root Cause Analysis (RCA) for troubleshooting and resolving the issues.
• Data Center Experience.
• Expert in raising the Service Requests and keep tracking of requests.
• Expert in Detecting and Resolving Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor.
• Expert in creating and debugging Views, Functions, Indexes, Cursors, Store Procedures, Triggers, Optimizing code and improving Efficiency.
• Data Modeling Experience including Physical and Logical data modeling using Erwin tool
• Extensively used repositories like Team Foundation Server (TFS), and Visual Source Safe.
• Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Hands on experience in installing, configuring, managing and troubleshooting SQL Server.
• Experience in database development, for creating complex database queries, Indexes, Views, Stored Procedures and Triggers in SQL Server.
• Testing methodologies and tools - Automation and Performance testing.
• Strong Communication & Management skills and Excellent Team player

TECHNICAL SKILLS:

Relational Databases: SQL Server 2017/2016/2 /2008R2/2005/2000, MS-Access 2000/2003/2007, My SQL 4/5, Oracle 9i/10g.

Cloud Technologies: Azure SQL Database, Azure SQL Data Warehouse, Azure Storage, AWS S2, AWS EC2

Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, BCP, ODBC, SQL OLEDB, DBCC, ADO, ADO.NET, Business Intelligence Studio.

Languages: C#, XML, SQL, T-SQL

Operating Systems: Windows 2016, Windows 2014, Windows 2008R2, Win ME/NT/XP, UNIX.

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP.

ETL: SSIS, SSRS, DTS.

Tools: Azure SQL Analytics, Query Performance Insight, Dynamics CRM, MS Visual SourceSafe, Source Control, MS Visio, Windows System Monitor, ServiceNow, JIRA, Remedy, Foglight, SQL Diagnostic Manager, Litespeed, SQL Safe, Veritas.

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

SQL Database Administrator

Responsibilities:

• Analyzing the Database Infrastructure / servers / storage and provide technical recommendations for improving the SLA times with business users and implement optimization changes for better performance for applications.
• Migrated SQL2008 applications to SQL2012 with Always On high availability clusters for disaster recovery and reporting.
• Migrated few of PROD SQL Databases to cloud environment SQL Azure.
• Implementation of Replication Models (for OLTP Servers) using Merge and Transactional (with updatable subscriber) on large terabyte databases.
• Involved in Fine Tuning and Performance and Query optimization of the Database as required by the application.
• Extensively used T-SQL Scripts for developing stored procedures, triggers, functions etc.
• Successfully restored 22 TB database having thousands of data files and shrink back to 6 TB of size.
• Implemented 2way Replication (Peer-Peer/Snapshot) between 1 Publisher and 3 Subscribers.
• Worked closely with Storage groups to find out the underlying Disk I/O sub system issues with SAN.
• Implementing the Security strategy for each environment and the required backup strategy as well.
• Used DMV’s and custom scripts to tune performance of SQL Server queries.
• Provided support for SQL Server Reporting Services (SSRS) including installation, configuration, report deployment, setting up report subscriptions and managing security.
• Designed and Implemented backup solution using third party backup tool called Dell Litespeed.
• 24 X 7 On-call support rotation for SQL Server database systems, products and services.
• Work with Microsoft PSS Support to troubleshoot and debug SQL Server / Windows problems.
• Develop and deploy trace files to audit DBA activities, DDL commands and Security events in SQL Server. Automate the process of reporting unauthorized activities.
• Design and develop database backup and recovery procedures.

Environment: MS SQL Server 2012/2008R2/2008,Windows clustering/ Always On, Microsoft Azure/Cloud environment (IaaS, PaaS, SaaS), SQL Lite Speed, Red Gate SQL Compare, SQL Sentry, Visual Studio 2010/2005 and Windows Server 2008/2003, T-SQL, PL/SQL, SSIS, SSAS, SSRS, Query Analyzer, SQL Profiler, Performance Monitor, BCP, SCOM, Active Directory, MS System Center 2012 and Microsoft Cluster.

Confidential, Richardson, TX

SQL Server DBA

Responsibilities:

• Installed/Configured and upgraded PROD/COB/UAT/DEV environments from SQL Server 2005/2008 R2 to 2012.
• Deploy High Availability and Disaster Recover solutions like AlwaysOn, Database Mirroring to provide multiple copies of production data that can be used for disaster recoveries.
• Installed SQL Server 2012 versions using PowerShell Desired State Configuration (DSC) and post install Server configuration.
• Created Merge Replication between different data centers. Resolved issues. Wrote PowerShell scripts for deploying SQL Server Databases ran that scripts in VSTS.
• Database backed up regularly & available in the event of a disaster to meet the organization’s Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).
• Worked on Cob tests during weekends to test COB environment by business users.
• Work closely with infrastructure and security teams in evaluation of hotfixes/security patches and make sure all environments are up-to-date.
• Extensively worked on auditing entire environment by building SQLMonitoring database to capture everything single thing in the prod environment.
• Successfully implemented a project to set up process of automated log shipping without primary server by just using backups.
• Monitoring the servers using Idera Diagnostic Manager third party software and backups using SQL Safe.
• Design, document and implement SSIS packages and stored procedures.
• Used TFS in environment for source control and managing development via tasks/bugs.
• Moved secured databases to AWS cloud environment from SAN.
• Provide expertise for using best RAID Technologies based on application requirement.
• Use DTA (Database Tuning Advisor), to identify indexes that can help improve performance.
• Used SSIS to move auditing files from SQL server to UNIX server.

Environment: MS SQL Server 2012/2008R2/2008/2005,Windows clustering/ Always On, AWS, Red shift, PowerShell, Idera SQL,T-SQL, SSIS, SSAS, SSRS,Idera Diagnostic Manager, Lotus Notes, Microsoft Outlook, Team Foundation System 2012,Active Directory,Visual Studio 2010/2005 and Windows Server 2008/2003.

Confidential, Jacksonville, FL

SQL Server Database Administrator

Responsibilities:

• Providing 24/7 support for critical production databases of Confidential Datacenters.
• Providing Primary DBA responsibilities for around 100 applications.
• Migrated the SQL Server 2008 to SQL Server 2012.
• Migrated the SQL Server 2000/2005 to SQL Server 2008 and 2008 R2 versions.
• Managed 2000+ databases and few huge databases which are more than 7TB.
• Installed SQL Server 2008 on hundreds of machines/clusters.
• Installed of MS SQL 2008 on production, Test and Development boxes.
• Working on Projects to provide DBA support for building SQL Servers for new applications (begin to end support).
• Planning for backup and recovery of database information and maintaining Hot Backups, Cold Backups.
• Working with Foglight(Monitoring tool) and Litespeed(Backup tool).
• Administering the MS SQL Server 2012, 2008, 2005 & 2000 by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and upgrading of SQL Servers.
• Performed Physical and Logical Data Modeling using Erwin tool for databases of varied sizes including VLDBs.
• Designing, Creating and Migration of DTS/SSIS packages to Development and QA Servers.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Migrated databases from existing 2000/ R2/2012 servers.
• Involved in General Database Administration, Query Performance tuning.
• Created (with respect to standards) Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks.
• Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Developed few reports using MS SQL Reporting Services.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Refreshes from Production backup to Stage and Development environments.
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.
• Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
• Extracted data from various sources like SQL Server 2005/2008/2012, Oracle, Teradata, .CSV, Excel and Text file from Client servers and through FTP.
• Working with Nexus Tickets (Any changes on staging and development environment need to Create Nexus Tickets).
• Working with Maximo Change Request (Any changes in Production database need to Create Maximo Tickets this should be approved by Global DBA team after changes made in stage and development environment).
• Involved in all ITIL process like Change management, Incident Management & Problem Management.

Confidential

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 dead locks 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, DTS packages.
• 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 databases.

Confidential

SQL Database Administrator

Responsibilities:

• Migrated Databases from SQL Server 2005 to SQL Server 2008R2 in Production and test Environments.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity and converting them into technical specifications.
• Creating databases and logins and users with permissions in SQL server 2005/2008.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
• Configuring and Troubleshooting Service Broker Objects in Service Broker for Stored Procedures.
• Backup and Recovery of Production Databases and Tuning them for better Performance.
• Deploying and Troubleshooting SSIS packages with a multitude of Data sources and complex data conversion logics.
• Creating Databases and Logins & users with permissions in SQL Server 2005/2008.
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring and SQL Server clustering.
• Created Linked servers accordingly in between the different servers based on the requirement.
• 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.
• Implemented Pager options to inform corresponding DBA basis on Each Job Status.
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Define database scripts versioning system to keep track of database versions for all environments.
• Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases.
• Performed Backup and recovery & Automation of Backups using maintenance plans.
• Enabled Transparent Data Encryption on critical databases.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
• Configured SSRS using configuration manager, created and maintained security roles and created new reports.
• Created and scheduled maintenance plans (database and log backups and cleanups).
• Used server scoped and database scoped DMV’s to trouble shoot issues.
• Identified and analyzed deadlocks in databases using SQL Server Profiler.
• Involved in full life cycle of the project from Requirement analysis, Design, Development and Testing.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to export data from other sources to SQL databases.

Confidential

Junior SQL DBA

Responsibilities:

• Planned and Successfully Installed SQL Server 2000, 2005 on the Production and Development Servers.
• Developing the successful Backup strategies based on Recovery models.
• Involved in DTS/SSIS Package, DTS Import/Export for transferring data.
• Administration of all database objects such as Indexes, Views and Tables
• Involved in implementation of replications like Transactional.
• Implement and creation of security policies and controls, user access and role management
• Implementing Database maintenance plan for Database consistence & Integrity.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Created various Jobs scheduled & ran jobs and troubleshoot the failed jobs.
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups.
• Maintaining and Monitoring Production, Pre-Production and Development database server environment.
• Having good knowledge on creation and scheduling of T-SQL jobs to run daily.
• Improved performance of slow running queries using Profiler and Statistics I/O by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.