Sr. Sql Server Dba Resume
Dallas, TX
SUMMARY:
- Eight Plus years of experience in Database Administration using MS SQL Server 2016/2014.
- Expert Level skills in providing 24x7 DBA Level 3 supports in Production, QA and Development.
- Day - to-day monitoring and maintenance, problem investigation and resolution, SQL and database optimization and tuning as well as researching, analyzing, and recommending patches, upgrades, and new technologies surrounding all aspects of data management using relational databases.
- Experience in installation, maintenance, and migration of different versions of SQL Servers ( 2016/ 2014/2012/2008 R 2/2008/2005/2000 ) in both OLTP and OLAP lower regions and Production environments.
- Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands, Database Engine Tuning Advisor.
- Working experience in Windows PowerShell Scripting.
- Experience in Data Modeling, Star Schema, FACT and Dimensional tables and Operational Data Store.
- Experience in Database Backup, Recovery and Disaster Recovery procedures.
- Experience in Clustered Servers to achieve maximum performance and uptime in production environment.
- Experience in Configuration, Implementation and Maintenance for Disaster Recovery Solutions Using Log Shipping, Failover Clustering, Database Mirroring & AlwaysOn: Availability Groups in SQL Server.
- Working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS. Configured report subscriptions both data driven and time driven.
- Upgrading/Migrating SQL Server to higher versions, 2005, 2008, 2012, 2014, 2016 and applying service packs and cumulative fixes.
- Well Experience in Performance Tuning (System level/Database Level/Query Level) and optimization.
- Implemented Latest Features like Data Compression and Backup compression reducing I/O and Transparent Data Encryption for encryption to secure data at rest and document the process.
- Experience in implementing AlwaysOn Clustering and Mirroring on physical and virtual machines.
- Designed and Configured Partitioning of Tables and Indexes to Improve query performance in SQL 2008 R2/SQL 2012.
- Monitoring SQL Server Error Logs, Disk Space growth, Clustering Environment.
- Working experience in SDLC in developing an application, with Installation, design architecture, data flow, Maintenance and Operations of a system.
- Thorough understanding of blocking/lock issues, Tempdb Optimization, Filegroup management.
- Conducted RCA for database incidents and problems.
- Taking backups using tools like Lite Speed.
- Excellent T-SQL skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, User defined data types, Cursors and functions.
- Played a key role in business requirements analysis, physical and logical Data modeling, application developments, testing, training, production support and Project review with client.
- Excellent Experience in Managing Security through Logins, Users, Permissions, Certificates, credentials.
- Experience with Agile/Scrum Methodologies.
- Experience in Creating Roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, using performance monitor/profiler for resolving deadlocks.
- Experience in working with VLDB databases up to 20TB, Managing Backups, Disk & Drive Space issues, managing indexes.
- Experience in Performance monitoring using Idera SQL Diagnostic Manager.
- Experience in using DMV and dynamic management functions (DMF) for finding out long running queries.
- Experience in deploying of windows application, web services and window services in Microsoft Visual Studio .Net IDE using C#.Net 1.1, C#.Net 2.0 VB.Net ASP.Net, ADO.Net and SQL Server.
- Experience using Resource Governor and Policy Based Management system for maintenance.
- Thorough knowledge on SAN environments, RAID levels, VMware Environments.
- Thorough understanding of tools like Perfmon, SQL Profiler, DTA, DB Artisan, Lite Speed, SQL sentry etc.
- Good team player with communication Interpersonal and business analysis skills.
- Exposure to multiple database platforms like Oracle, MySQL and Mongo DB.
- Experience in working with huge databases, troubleshooting issues and documenting the causes.
TECHNICAL SKILLS:
Programming Languages: T-SQL. PL/SQL, Unix, C#, ASP.Net
RDBMS: MSSQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000 /7.0, SYBASE, MYSQL, ORACLE
Web Tools: Internet information Server (IIS), FTP, TCP/IP, SMTP, LAN, MS-Outlook Express
Operating Systems: Windows XP/NT/ 2000/2003/2008/2012, Vista, UNIX
Database Tools: SSMS, BIDS, DTA, SQL Profiler, DTS, DTSRUN, MS Visio, Import & Export (DTS), DTSX Change, SSRS, SSAS, SSIS, Erwin, Lite Speed, Crystal Reports 10.0, Share Point, SQL CMD
Utility Tool: MS Office, MS Project, Visual Source Safe 6.0 (SCOM), Visio 2007, Perfmon, Backup Utility
Virtualization: VMware VSphere Client, EXS 3.0,4.0,4.1,5.0, and 5.1
PROFESSIONAL EXPERIENCE:
Confidential, Dallas, TX
Sr. SQL Server DBA
Responsibilities:
- Principal responsibility is to troubleshoot and fine-tune out SQL environment.
- Supported SQL 2016/ 2014/2012/2008 /2005 databases in clustering environment (A/P & A/A) including database mirroring/Log shipping on critical large-scale databases.
- Analyzed long running slow queries and tune the same by creating appropriate indexes, removing duplicate code and creating calculated columns to optimize application and system performance.
- Extensively worked with SQL Profiler, Activity monitor, Perfmon, DMVs, DMFs and DTA to tune the databases, queries, performance related issues like memory, CPU and I/O issues.
- Maintained production and development databases in some non-stop heavy transactional and reporting environments.
- Migrated SQL upper versions like 2012 & 2014 by using side by side upgrade process.
- Deploying SSIS packages in production environment.
- Maintained the data, database backups and restoration, backup strategies, scheduled backups.
- Refreshed development, UAT, Training and Testing Databases with latest production Data upon testing team’s request.
- Performance tuning of SQL queries and stored procedures using SQL Profiler and index Tuning Wizard.
- Involved in testing, bug fixing and documentation for the project.
- Implemented and tested Database Backup to a Data duplexing device and confirm RPO and RTO to implement retention of backup and storage.
- Served as a part of DBA team which was involved in the maintenance of the SQL Server databases for the Production as well as the development environments.
- Implemented and maintained AlwaysOn Availability Group in SQL 2012/2014.
- Set up the Virtual machines through VMware software in development & Production Environment.
- Created Database Maintenance Plan for the better Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
- Developed partitioned views and tables for the purpose of security and fast upload.
- Installed SQL Server 2014/2012/2008 R2 on Windows Clustered and standalone environments with latest service packs.
- Configured and deployed SSRS reports.
Environment: SQL Server 2008/2008R 2/2012/2014/2016, Windows 2008, Windows 2008 R2, Oracle DB, VMware, Clustered, Active Directory, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Profiler, Tuning Advisor, SQL, PL/SQL.
Confidential, Houston, TXSr. SQL Server DBA
Responsibilities:
- Involved in migration from MS SQL Server 2012 and SQL Server 2014.
- Involved in documentation and implemented a disaster recovery system.
- Performed all aspects of database administration, including data modeling, backups and recovery.
- Experienced in Security Issues such as creation and granting permissions on various Objects. Assign permission to users, roles, and object.
- Analyzed long running slow queries and tuned the same to optimize applications and system performance and Performed DBCC Checks.
- Diagnosed and tuned the server optimal performance using SQL Server Dynamic Management Views (DMV), SQL Profiler and index Tuning Wizards.
- Rebuild Indexes and Tables as part of performance tuning exercise.
- Successfully migrated data to new location using Snapshot Replication, and implemented Merge Replication to support up to date record of Inventory Information.
- Designed overall database, such as creating normalized databases, authentication, and query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types using T-SQL Statements.
- Experienced hands on with Bulk Insert, BCP and Database consistency check using DBCC commands.
- Worked closely with audit team to implement SOX-Audit on all SQL servers.
- Experienced in Data Migration using SSIS across different databases like Oracle, MS Access, Sybase, & Flat Flies.
- Monitored and generated report for the database infrastructure and these reports are submitted to management on regular basis.
Environment: SQL Server 2012/2014, Windows, SSRS, SSAS, SSIS, Commvault, Control-M, Idera monitoring tools. HPSM ticketing systems, SharePoint 2007 and 2010.
Confidential, San Antonio, TXSr. SQL Server DBA
Responsibilities:
- Installed and configured SQL Server 2008 R2/2012.
- Involved in Migrating SQL Server Databases from SQL Server 2008/2012 to 2012/2014.
- Experienced with performance turning, use of DMV’s, analyzing Locks and Deadlocks, checking the threshold values and baselines.
- Experience in Deploying and Consolidating Remote Instances.
- Involved in DBCC checks, solving database issues with Index fragmentation, Data Integrity, index tuning, Update Statistics, Error and Event Handlings, Query Optimization.
- Configured AlwaysOn Availability Groups for Disaster Recovery.
- Configured and monitored of database Mirroring and Log Shipping for multiple databases on geographically separated cluster environments to provide High Availability and Disaster Recovery.
- Performed daily routine DBA tasks such as deployments, incident tickets, handling user permissions and space issues on production servers.
- Installed Active-Active and Active-Passive SQL Server 2012/2008 failover cluster on Windows SQL Server 2008 R2 cluster virtual environment.
- Tuned the queries based on high CPU, Memory and Logical reads and writes, for performance improvement.
- Deployed SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
- Provided production support for 24x7 over weekends on rotation basis.
Environment: MS SQL Server 2014/2012/2008 R2/2008, Windows Server, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS).
Confidential, Austin, TXSr. SQL Server DBA
Responsibilities:
- Worked in the administration, security and support of all SQL servers and databases.
- Involved in redesigning and redefining data warehouse and provided necessary documentation.
- Configured and monitored regular database backups and disaster recovery plans.
- Installed and administered clustered and stand-alone SQL server 2008 and 2012.
- Automated SQL Server Administration tasks.
- Designed and implemented backup plans as per the data retention policy outlined in the BRD (Business Requirement Document).
- Supported the multi-tier production and development environments.
- Solved several issues which comes from ticketing system and responsible to close the tickets.
- Migrated SSIS packages from SQL Server 2008 to SSIS 2012.
- Provided 24x7 production supports to the clients and application groups.
- Created and maintained the SQL Agents jobs and configured them to send the alerts and email on failure to DBA group.
- Installed upgraded and applied the latest service packs/hot fixes.
- Provided High Availability through Clustering (Active/Active and Active/Passive), Mirroring, Replication (Transactional), and AlwaysOn.
- Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing and Contained Databases.
- Checked Database Health by using DBCC Commands and DMVS.
- Rebuilt and monitored the indexes at regular intervals for better performance.
- Experienced in suing SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
- Reviewed, Optimized, and deployed database scripts requested by Application Development Team through change request.
Environment: SQL Server 2008/2012, Windows 2008, Clustered, DB2, Active Directory, SSIS, SQL Loader.
Confidential, Pennsylvania, PASr. SQL Server DBA
Responsibilities:
- Installed and maintained SQL Server 2008 R2/2012 Servers. Dedicated production support for 24x7.
- Supported an Active—Active/Passive Cluster environment.
- Supported large scale databases with few databases more than 2 TB.
- Created Database Partitioning to improve query performance.
- Supported in Performance Tuning of SQL server environment with UAT load testing for capacity and performance analysis.
- Utilized TFS for collaboration and code safekeeping.
- Implemented Resource Governor on SQL Server 2008R2.
- Configured, Installed and Maintained for SQL Server in Clustered (Multi-Node) and non-Clustered environments.
- Maintained High Availability such as Replication, Mirroring as far as database disaster technique.
- Experienced in supporting and developing High Availability client server OLTP and OLAP database applications.
- Created stored procedures for the business logic using T-SQL.
- Installed, Configured and Deployed the Reports using SSRS with Scale-Out topology.
- Designed for Logical databases for SQL Server 2000/2005/2008 R2/2012.
- Upgraded and migrated the Servers from SQL Server 2000/2005 to SQL Server 2008 R2/2012.
Environment: SQL Server 2000/ 2005/2008/2008 R2/2012, Windows NT/2008R2/2008/2003, T-SQL, SSIS, and SSRS ETL.
Confidential, Bloomfield, CTSr. SQL Server DBA
Responsibilities:
- Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
- Worked on IMS performance issues like update statistics, rebuilding the indexes at regular intervals for better performance.
- Reviewed developer SQL code to ensure adherence to client standards and general best coding practices.
- Worked on Compliance issues.
- Analyzed long running slow queries and tuned the same to optimize application and system performance.
- Monitored SQL Server performance using profiler to find performance and dead locks.
- Rebuilt the indexes at regular intervals for better performance.
- Designed and implemented comprehensive Backup plan and disaster recovery strategies implemented.
- Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
- Managed the clustering environment.
- Implemented the online indexing on 24x7 environments.
- Migrated data to new location using Snapshot Replication, and implemented Transactional Replication to support up to date record of Inventory Information.
- Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedure.
- Involved in DATA Analysis like Analyzing and Accessing collection of Data.
- Managed to set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/mas server options.
- Implemented all database development enhancements to multiple SQL Server databases to ensure a flawless functioning of production environment.
- Performed installations & performance tuning, managed capacity planning & user accounts and implemented database security for multiple instances of development, certification, QA and production SQL Server databases.
Environment: SQL Server 2012/2008R2/2008/2005 with clustering, Replication, MySQL, T-SQL, Windows 2003 64-bit, SQL/PLSQL, DTS, SSIS, Profiler.
Confidential, Chaska, MNSQL Server DBA
Responsibilities:
- Managed and Administrated SQL Server 2008R 2/2008/2005/2000 production and Non-production servers.
- Installed and configured SQL 2005 servers in non-clustered environments. Documented the installations and configuration.
- Analyzed SQL Servers and Databases and came up with a plan for consolidation based on usage, performance, and compatibility.
- Implemented and maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
- Migrated databases from SQL 2000/2005 to SQL 2005/2008/2008 R2.
- Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
- Extensively worked on Profiler, Perfmon, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
- Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary join, cresting useful clustered index and non-clustered indexes.
- Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.
- Managed Security using SQL Logins, Roles, and Security Modes for various users.
- Configured the Report server. Created, deployed and managed reports using SQL Server Reporting Services (SSRS) and created Ad-hoc reports.
- Analyzed access database usage and migrated databases to SQL.
Environment: SQL Server 2000/ 2005/2008/2008 R2/, T-SQL, Windows 2000/2003 and SharePoint.
Confidential, Minneapolis, MNSQL Server DBA
Responsibilities:
- Worked on Client/Server tools like SQL Server Management Studio (2005), SQL Server Enterprise Manager (2000) and Query Analyzer to Administer SQL Server.
- Migrated SQL Server 2000/2005 databases into SQL Server 2005/2008/2008 R2 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
- Monitored transactional replication, Database mirroring on production, QA and Development servers.
- Migrated DTS packages into SSIS packages.
- Handled large size databases with clustered and standalone environment.
- Configured Transactional replication on migrated server.
- Worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
- Developed, deployed and monitored SSIS packages including upgrading DTS to SSIS.
- Integrated SQL traces with Perfmon log to have better graphical analysis to find system bottlenecks.
- Implemented SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Created Database maintenance planner for the performance of SQL Server which covers Database Integrity Checks.
- Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
- Experienced in Data modeling and metadata services.
- Monitored SQL Server performance using profiler to find performance and deadlocks.
Environment: T-SQL, MS SQL Server 2000/2005/2008 R2, SSRS, Query Analyzer, Visual Studio 2005, Window Server 2000/2003, IIS, SSAS