Sr. Sql Server Dba Resume
Owings Mills, MarylanD
SUMMARY
- Over 10 years of professional work experience in RDBMS design & modeling, development, Implementation, administration, performance tuning & monitoring work experience spans across financial services, Mortgage projects, HealthCare Insurance and Telecom domains on multi large - scale and highly visible projects. Experienced in SQL Server versions: 2016, 2014, 2012, 2008, 2008R2, 2005, 2000, 7.0 & 6.5.
- Microsoft Certified Professional in Administering SQL Server 2012,2014
- Expertise in installing SQL Server 2000/2005/2008 R2,2012&2014&2016 instances and applying service packs and hot fixes using Slip Streams with minimal production downtime.
- Extensive experience in designing and administration of SQL Servers in multi node clustering with Active/Active, Active/Passive Architecture.
- Expertise inSQL ServerStorage Structures andSecurityArchitecture for databases residing onSANstorage.
- Implemented different types of High Availability Solutions & Disaster Recovery scenarios for various business units.
- Expertise in Configuring Fail-over Cluster (Active/Active, Active/Passive) environments, depending on the application and business requirements.
- Expertise in setting up Always on Availability Groups Solution in SQL Server 2014 & 2016 Servers
- Expertise in setting up Peer to Peer replication (P2P) & Transactional Replication in SQL Server 2014 & 2016 across 3 datacenters in our Environments.
- Expertise in setting up Transactional Replication between On Premises SQL Server to Amazon Cloud RDS & EC2 Instances
- Expertise in setting up Log shipping between SQL Server 2008R2 to 2014 Instances.
- Expertise in setting up Transactional Replication in SQL Server 2012 & 2014 & 2016 Instances.
- Expertise in setting up Database mirroring between SQL Server 2008/2008R2 Instances.
- Designed and implemented Disaster Recovery (Backup/Restore) Strategies involving very large and highly transactional databases with sizes ranging from 100GB to a 5TB. Performed point-in-restore for critical issues using the log tail backup.
- Experienced in implementing TDE (Transparent Data Encryption) to secure data at rest and document the process.
- Expertise in Configuring In-Memory OLTP engine of SQL Server 2014.
- Performance Tuning and Optimization (PTO) using Tools such as SQL Pro filer, Windows performance monitor, Dynamic management views(DMV’S),Extended Events, Database Engine Tuning Advisor (DTA).
- Involved in Huge data migrations, transfers using utilities likeData Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
- Experience in developing Capacity Planning Reports (database growth estimation and Server disk space) and involved in SQL Server Consolidation projects.
- Identified, resolved database locks & h/w -related issues, Client/Server connectivity, Query Optimization using DMV’s & Functions, Profiler, perfmon, DTA where necessary, Performance slow-downs due to locks, blocking, index issues and Database Consistency.
- Extensive experience in controlling the user Privileges, Monitoring the security and Audit issues as per standards.
- Performance and Tuning of SQL Server using Index tuning, profiler, PerfMon, DTA, DMVs and DMFs
- Expertise in resolving locks, deadlocks, handling Isolation level and concurrency effects, detect
- Experience with PowerShell scripting, to extract Database and Server Level Information.
- Experience with creating customized Indexes in Log stash servers and Configured Kabana dash boards & visualization & Timelines for MongoDB metrics & SQL Server Performance metrics.
- Expertise in deploying SQL Server in AWS RDS.
- Expertise in migrating SQL Server Instances to AWS Ec2 Instance.
- Expertise in Migrating SQL Server Instance to Microsoft Azure Cloud.
- Expertise in Hosting SQL Server Databases on Azure Cloud.
- Experience in MongoDB Configuration and Administration.
- Experience with SQL coding standards in writing Stored Procedures, Triggers, Views, SQL functions, Error Handling Techniques and resolving locking and deadlocking issues by modifying the SQL code.
- Worked on Archival and Purging Process to retain data with time period on OLTP Servers and Archive and Purge old and unused data to OLAP.
- Deployed objects for releases through TFS 2013 & 2015.
- Extensively worked on supporting 24x7 in a Production Environment and managing - Onsite & Offshore team
- Involved in User Acceptance, system testing, bug fixing & documentation of the project.
- Experienced in Oracle Installation and configuration and administration.
- Skilled in managing and creating the new Oracle databases
- Worked directly with Microsoft Support teams to resolve SQL and OS issues on SQL clusters
- Good knowledge and working exposure in Storage Concepts of RAID levels and SAN environment.
- User training, Documentation, Troubleshooting, Event & Incident management and DBA support
- Flexible and versatile to adapt to any new environment and has the ability to work individually or in large teams involving long hours with strong inclination for finishing job before project deadline
TECHNICAL SKILLS
- MS SQL Server 2014/2012/2208 R 2/2005/2000/7.0/6.5
- High Availability Solutions(AlwaysOn
- Clustering
- Replication
- Database Mirroring and Log Shipping)
- MS SQL Reporting Services(SSRS) 2005/2008R2
- MS SQL Server Analysis Services(SSAS) 2008R2/2005/2000
- MS SQL Server Integration Services(SSIS) 2005/2008R2
- DTS Packages
- Erwin Designer 2000
- MS-Access 2010/2007/2003
- Oracle 9i& 10g
- DB2
- Windows NT
- Windows Server 2008/2000
- Windows XP/Windows 7
- Unix
- Shell script
- VB Script
- C/C++
- HTML
- XML
- MQ Web Services
- UML
- MS Visio
- MS office 2010
- Microsoft Visual Source Safe
- Subversion
- Microsoft Team Foundation Server(TFS)
- Window SharePoint Services 3.0. i3 Performance Monitor
- SQL Lite Speed
- SCOM
- AWS
- Redgate SQL Compare Utility
- Octopus deployment tool.
PROFESSIONAL EXPERIENCE
Confidential, Owings Mills, Maryland
SR. SQL Server DBA
Responsibilities:
- Supporting 4450 databases over 550 servers which includes prod, stage and dev environments.
- Involved in the project to migrate databases from different sites to consolidated database center.
- Experience inSQLServer 2014 & 2016 installation and configuring high availability on multi node servers.
- Expert in Implementing high availability features ofSQLServer solutions, including Always on, Log shipping, Replication, Mirroring and Cluster Environments.
- Involved in troubleshooting transactional replication.
- Experience in Database Backup, Recovery and Disaster Recovery procedures inSQLSERVER and Design Tested and Implemented various Failure Strategies base on business requirementsInvolved in capacity planning.
- Migrated databases fromSQL2008 andSQL2012 toSQL2014 & 2016 SQL Servers.
- Experience in implementing Table Partitioning, CDS and Encryption features
- Experience in optimizing code and improving efficiency in databases including re-indexing, updating statistics, reviewing and recompiling stored procedures, Triggers, Data Consistency checks
- Experience working in SAN network and RAID configure Environment
- Reviewing T-SQLcode to verify and meets standards for both performance and error handling according toDBAstandards.
- Extensive experience in controlling the user Privileges, Monitoring the security and Audit issues as per standards.
- Participated in enterprise release management Database deploys (QA to Prod)
- Worked on problem management, performance tuning, identifying locking and blocking for long running queries.
- Implemented TDE (Transparent Data Encryption) to secure data at rest and document the process.
- Experience in Database administration activities forDB Security(creating logins, users, roles, and assigning permission to them
- User training, Documentation, Troubleshooting, Event & Incident management and DBA support
Confidential, Philadelphia, Pennsylvania
Principal, Database Engineer
Responsibilities:
- Served as DBA or project lead in the completion of 80+ medium- to large-scale implementations, managing projects from business requirements analysis to solutions delivery and support.
- Managed approximately 500 SQL Servers & 4000 databases (2008R2 and 2012/2014/2016 ) with team of 7 DBAs in 24x7 production environment, provided on-call & day-to-day support.
- Migrated approximately 300 Servers from SQL Server 2008 to SQL 2014/2016 Server, with database sizes ranging from 100GB to 5TB.
- Expertise in installingSQLServer 2000, 2005, 2008 & 2008R2 and 2012, 2014, 2016 applying service packs.
- Created Fail-over Cluster (Active/Active, Active/Passive) environments, depending on the application and business requirements.
- Expertise in Datacenter Migrations.
- Implemented & Configured AlwaysOn Availability Groups Solution in SQL Server 2014 & 2016 Servers.
- Configured Peer to Peer replication (P2P) & Transactional Replication in SQL Server 2014 & 2016 across 3 datacenters in our Environments.
- Expertise in Configuring Transactional Replication between On Premises SQL Server to Amazon Cloud RDS & EC2 Instances
- Configured Log shipping between SQL Server 2008R2 to 2014 Instances.
- Configured Transactional Replication in SQL Server 2012 & 2014 & 2016 Instances.
- Configured Database mirroring between SQL Server 2008R2 Instances.
- Experience working on Hyper-V and VMware environments
- Implemented TDE (Transparent Data Encryption) to secure data at rest and document the process.
- Experience with PowerShell scripting, to extract Database and Server Level Information.
- Experience with creating Indexes and dash boards & visualization in Kabana, Elastic Search.
- Expertise in deploying & Migrate SQL Server to AWS RDS & EC2 Cloud Instances.
- Expertise in Migrating SQL Server Instance to Microsoft Azure Cloud.
- Experience in Mongo DB Administration.
- Database Administration for all databases (Production /Development/UAT), with day to day tasks includes database monitoring, Backups, Space Management, Resource Utilization on servers.
- Involved in managing day-to-day DBA activities such as checking SQL Server logs, event logs, daily jobs, backup jobs and moving the backup files to SAN, by creating users and roles for login authentication, validating permissions and removing orphan users.
- Created triggers to enforce data and referential integrity, on the specific table which helped users to prevent inserting invalid data or to respond to a certain events like INSERT, UPDATE and DELETE.
- Involved in unit Testing, user Acceptance testing to check whether the data is loading in to target, which was extracted from different source systems according to the user requirements.
- Participated in enterprise release management Database deploys (QA to Prod)
- Performed DB refreshes and data scrubbing per risk management standards
- Routinely tested DB file backups to confirm validity
- Proactively monitored DB server state information by utilizing custom stored procedures (with the results stored in a utility DB)
- Implemented file-groups to manage VLDB’s efficiently
- Worked on Red gate to compare data & schema differences and monitoring SQL server performance and backup compression and also deploy multiple scripts to multiple servers.
- Responded to trouble tickets and resolved all support related issues
- Routinely monitored Windows and SQL Server error logs to diagnose and troubleshoot any known issues
- Monitored SQL environment through Ignite, extended events, policy-based management, and DMV monitoring
- Worked on problem management, performance tuning, identifying locking and blocking for long running queries.
Environment: 2-node Clustered SQL server 2014/2012/2008 R2/2008/2005, Active-Active& Active-Passive Clustering, Windows 2012/2008R2/2008/2003, Transactional Replication, PowerShell, i3 Performance Monitoring Tool, Upgrade Advisor, SQL Profiler, Performance Monitor, DMV’s, T-SQL, SSIS, VB.NET 2003/2005, and JAVA, FTP/SFTP.
Confidential, Westlake, Texas
Sr.SQL Database Administrator
Responsibilities:
- Architected and maintained Erwin logical and physical data models of the data warehouse and data marts.
- Depending upon the application requirement, and the size of the databases, used both Side-by-Side and In-place migration methodologies.
- Established data architecture and BI best practices, standards and data models; recommended data warehouse and reporting performance-tuning techniques. Mobilized and directed BI professionals and offshore development team of 60+
- Upgraded SQL 7.0/2000/2005 Servers to SQL 2008/2012 Server, 60+ production databases, with database sizes ranging from 100GB to 3 TB.
- Installed and Configured SQL Server 20 and 32 bit) on Standalone and Microsoft Clustered servers and Applied the latest Service Packs, Hot fixes and security patches.
- Used RML Utilities and Upgrade Advisor, for analyzing the performance improvement of SQL Server 2008 over SQL Server 2000 and the changes that need to be made before and after SQL 2008 Server upgrade.
- Implemented SDLC development and acceptance test environments.
- Developed data Migration and data validation PL/SQL scripts from old systems to new systems.
- Architected and managed all changes to the data models. Created data models, solution designs and data architecture documentation for complex information systems
- Designed, developed, and maintained a bulk processing backend which allowed clients to update live
- Involved in data cleansing procedure by removing old, corrupted or irrelevant data in consultation with the teams.
- Documented ETL strategy then captured and documented detailed design specifications for the ETL process.
- Involved in Converting, Designing, deploying and maintaining more than 250 packages which included lot of data operations and analysis processing tasks.
- Involved in migrating DTS packages to SQL Server 2008 Integration services packages, using DTS Exchange. For deploying SSIS packages in different environments, used configuration files.
- Involved in managing day-to-day DBA activities such as checking SQL Server logs, event logs, daily jobs, backup jobs and moving the backup files to SAN, by creating users and roles for login authentication, validating permissions and removing orphan users.
- Experience in Database administration activities forDB Security(creating logins, users, roles, and assigning permission to them
- Used SQL LiteSpeed v4.8, to backup and restore databases, scheduled TSM (Tivoli Storage Manager) backup jobs every night to achieve the backup files from different servers to Data Center.
- Strong experience onhigh availabilitySQL Server solutions, includingReplication Models(Snapshot/Transactional) andSQL Server clustering(Active-Active, Active-Passive).
- Installed and Configured SQL Server Analysis Services processed the cubes and dimensions after migrating the OLAP databases.
- Resolved various performance issues, by running DBCC commands, using SQL Tracer and SQL Profiler, to track down Dead locks and long running queries.
- Configured Database Mail and scheduled database maintenance tasks, alerts to the operator by means of email in case of success/failure of job and to solve emergency scenarios like server shutdown, when the database is in emergency/suspect/shutdown mode
- Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
Environment: Clustered SQL server 2000/20 servers, Windows server 2003 R2, Enterprise x64 Edition Service packs 2, OLAP, Transactional Replication, Failover Clustering, SQL Lite Speed V4.8, HP Open view, DTS Exchange, RML Utilities, Upgrade Advisor, SQL Profiler, SQL Server Configuration Manager, T-SQL, DTS, SSIS, SSAS, Informatica, VB.NET 2003/2005, Erwin 4.0.
Confidential
Database Administrator
Responsibilities:
- Installing and Configuring SQL Server 20 and 32 bit) on Standalone and Microsoft Clustered servers.
- Applying latest Service Packs and Hot fixes and Upgrading SQL Server 2000 to SQL Server 2005/2008.
- Architecting the solutions by using SQL Server and mentoring developers.
- Implementing T-SQL Coding Standards and writing policies and procedures for data management.
- Writing & tuning Stored Procedures, Functions, Triggers and Views in Transact - SQL for optimal performance.
- Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
- Involved in Installation and designing MS SQL 2000/2005/2008, created various databases for Development and Testing Environment using SQL Server 2000/2005/2008 and managed database locations and size.
- Used Erwin data modeling tool for creating the logical and physical data models and for forward and Reverse engineering and also used the feature complete model comparison for making the data models synchronized.
- Administrative task including full and differential backups, database security by creating users and roles for login authentication and validating permissions.
- Created complex triggers on tables for logging the data, wrote complex queries and joins as per the business requirements.
- Developed and designed SSIS packages for importing the data from ODBC sources, MS Access, MS Excel, flat files etc.
- Involved in migrating DTS packages to SQL Server 2005 Integration services packages.
Environment: SQL Server 2000/20 R2, Oracle, Windows 2000/2003.2008 server, Query Analyzer, SQL Profiler, Enterprise Manager, SQL Server Configuration Manager, T-SQL, DTS,SSIS, SQL Server Reporting Services (SSRS), SSAS, Windows SharePoint Services 3.0,, ASP.NET, SQL Services, ER Studio.
Confidential
SQL Database Administrator (Junior DBA)
Responsibilities:
- Installed SQL Server 2005 on Windows Server 2003 and applied service packs and hot fixes
- Migrated SQL Server 2000 instances to SQL Server 2005
- Established relationships amongst various entities; designed ER diagrams
- Normalized data till the 3rd NF de-normalized selected tables, as necessary
- Designed database schema using third party tools like Erwin
- Researched and presented technical documentation to set standards, guidelines and best practices for SQL Server database installation, administration, Backup & restore procedures, database security, and SQL database development across the enterprise
- Documented and presented capacity planning projections
- Created databases, and database objects that included: tables, views, indexes, stored-procedures, triggers, functions, cursors.
- Created complex triggers on tables for logging the data, wrote complex queries and joins as per the business requirements.
- Created and managed database users, logins, and administered database security
- Developed and utilized DTS Packages extensively for ETL requirements (uploaded data from Oracle, SQL Server, & flat files)
- Developed T-SQL scripts to enforce business rules
- Setup log shipping between various sites to support planned and unplanned application failovers
- Optimized the performance of queries by removing unnecessary columns, eliminating redundant and inconsistent data, normalizing tables, establishing table joins, and creating indexes on the most frequently queried columns
- Resolved performance related issues due to excessive blocking, and deadlocking
- Created DTS Packages based on the business requirements and migrated some DTS Packages to SSIS Packages
- Rebuilt an existing Data Transformation Services (ETL) system that supports the BI processes
- 24x7 supports in a Production Environment & On call Support.
Environment: SQL Server 2000/2005, Windows Server 2003, IIS 6.0, DTS, SSIS, SSRS, BIDS, SQL Server Profiler, VB Script, VB.net, Index Tuning Wizard, Database Tuning Advisor, ERWIN