We provide IT Staff Augmentation Services!

Sr. Database Administrator (sql) Resume

St Louis, MO

PROFESSIONAL SUMMARY:

  • Having 13+ years of experience in MS SQL Server DBA (2017,2016,2014, 2012, 2008,2008R2, 2005, and 2000)
  • Expertise in Installation, Configuration, Patches, Upgrades & Administration for SQL Servers in Clustered (Failover) & Non - Clustered Environments.
  • Strong experience in Upgrades from lower level to higher level version.
  • Worked on Configuration, Implementation and Maintenance for Disaster Recovery solutions Using Log Shipping, Replication technologies like Transactional, Snapshot & Merge replication in SQL Server 2008r 2/2012/2016.
  • Experience in scheduling Backups and Restore, Log Shipping and Maintenance plans using Native & Third-party tools (LiteSpeed, Redgate, and Tivoli Data Protection).
  • Experience in configuring Always On with High Availability (HA) and Disaster Recovery and Windows Server Failover Clusters.
  • Experience in creating and managing database in Azure platforms.
  • Experience in using Change Data Capture (CDC).
  • Participated in planning of Disaster Recovery Planning, Execution and Testing.
  • Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
  • Experience in Configuring and Maintaining Database Mirroring and Database Snapshots.
  • Experience in Business Intelligence tools like SSQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analytical tool (SSAS).
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Enterprise Standards.
  • Good knowledge of Database architecture & modeling,
  • Expertise in building the knowledge management system for all the ongoing issues.
  • Experience in solving Database issues with Index fragmentation, CPU Bottleneck, I/O Bottleneck, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.
  • Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor.
  • Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage on distributed systems.
  • Good knowledge in windows server and active directory configuration
  • Expert in Database Capacity Planning and maintenance.
  • Participated in Server offline Investigation & ERD
  • Supporting and configuring SQL Server Analysis Services (SSAS).
  • Knowledge about in Dimensional Data Modeling Star and Snow Flake Schemas.
  • Implementing efficient Database Design principles including Partitions and Compression techniques.
  • Experience in creating documentation about the process and environment.
  • Experience in tuning performance at Server, Database and Query level.
  • Participated in 24/7 on Call Support for Production Databases.

TECHNICAL SKILLS:

Databases: MS-SQL Serve 2008R 2/ 2012/2 .

Languages: T-SQL. PowerShell.

SQL Server Tools: SQL Server Management Studio (SSMS), Enterprise Manager, SQL Server Configuration Manager ( SSCM),Index Tuning Wizard, Database Tuning Advisor Wizard (DTA), Profiler, Query Analyser, Export Import, Business Intelligence tools (SSIS),SSRS,SSAS,DTS,TDE,Web technologies like Internet Information Services (IIS),Surface Area Configuration (SAC),Change Data Capture (CDC)

Operating systems: Windows Servers 2003/20008r 2/2012/2016.

Thirdparty Backup Tools: EMC Networker, REDGATE SQL Safe, LiteSpeed

Monitoring Tools: Foglight 5.6, HP Site Scope, Perfmon.

Ticketing Tools: Remedy 7.6, HPSM, and JIRA

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis, MO

Sr. Database Administrator (SQL)

Environment: Microsoft SQL servers 2012/2014/2016 on windows Servers 2012/2014/2016

Responsibilities:

  • Involved in Install SQLServer 2008R2/ 2012/2 on Standalone and Clustered Environments.
  • Upgraded /Migrated of SQL Server from version 2008r2 to 2012/2016/2017.
  • Installed Microsoft Service Packs/Patches/Hot fixes to keep the servers up-to date.
  • Configured and administered SQL Clusters (Active/Passive, Active/Active), Database Mirroring, Replication and Log shipping.
  • Conducted Backup and Restore of Databases and Schedule Maintenance plans to perform regular Backups.
  • Performed Attach/ Detach, BCP, Import & Exports and Copy Database Wizard.
  • Query Optimization and Performance tuning for optimization like maintaining/creating indexes, Create/Update Statistics, Tuning SQL queries.
  • Analyzed Performance using Performance monitor in order to identify the bottleneck such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
  • Troubleshoot Memory Errors/Query Processing and usage of Memory and resolving errors pertaining to insufficient Memory.
  • Troubleshoot and resolved Blocking, Deadlocks and Long Running Queries.
  • Performed Data Transfer/Migration using Export/Import and Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
  • Deployed and monitored SSIS Packages including upgrade from DTS to SSIS.
  • Utilized DMV’s, Data partitioning and Performance Dashboards reports with SQL Server2012.
  • Configured Snapshot, Transactional and Merge Replication of SQL Server databases and Troubleshoot Replication Problems.
  • Created and Managed SQL Server Logins and Users as per the requirement with specific roles and permissions on production servers.
  • Created various Jobs scheduled & ran jobs and troubleshoot the failed jobs.
  • Experience in handling Critical issues like P1/P2, involved in Recovery bridge calls and Co-Ordinate with respective teams to resolve the issues within the SLA timelines.

Confidential, Phoenix, Arizona

Sr. SQL DBA

Environment: MS SQL servers 2008r2/2012/2014 on windows servers 2008r2/2012/2014

Responsibilities:

  • Installed, managed and administrated the MS SQL Server 2008R2/ 2012/2014/2016 Production and Non Production Servers.
  • Involved in Migration of SQL Server 2008R2 to 2012/2014/2016 .
  • Experience in creating and managing database in Azure platforms.
  • Migrated data/databases from Oracle to SQL environments.
  • Installed Oracle tools and drivers on SQL server for creating Linked Servers.
  • Involved in Configured AlwaysOn Availability Groups for DR and Reporting.
  • Worked extensively on Data Refreshes from Production to Test environments , automated the whole data refresh process at database level using Power Shell scripts , stored procedures , Backups and SQL Agent jobs without having any performance impact on Production server.
  • Monitored Log shipping/Transactional Replication and trouble shooting of errors.
  • Extensively worked on Profiler, Perform Counters, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
  • Implemented Database Mirroring and Transactional Replication as a part of DR plan.
  • Rebuilt indexes with different fill factors and update statistics manually.
  • Written T-SQL code to automate the SQL Server failed logins , SQL database restore jobs.
  • Debug and fine tune the application code SQL for the optimal performance of the database.
  • Experience in Maintaining SQL Server Security including the creation of logins and users, configuring permissions and assigning roles to users as required.
  • Configured Database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions.
  • Used Database Consistency Checks - DBCC commands for database maintenance
  • Detected and Resolved Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor
  • Running Index Tuning wizard for optimal query performance
  • Performed all aspects of database administration, including backups and recovery
  • Handled orphan users while moving databases.
  • Scheduled weekly jobs and Maintenance tasks for better performance, created the alerts with Database Mail SMTP.
  • Creating and Modifying Tables , T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
  • Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).
  • Supporting and configuring SQL Server Analysis Services (SSAS)
  • Created DB objects such as Tables, Stored Procedures, Views and Triggers as required.
  • Prepared the reports for the day-to-day as well as weekly/monthly purposes
  • Actively participated in determining the database schema , database schema changes, implementation plan for database schema releases in coordination with developers and data models in adherence with Organization policies
  • Proactively monitored , determined and solved issues at SQL/database/server levels

Confidential, Oakland, CA

Sr. SQL DBA

Environment: MS SQL servers 2008r2/2012/2014 on windows servers 2008r2/2012/2014

Responsibilities:

  • Installed, managed and administrated the MS SQL Server 2008r2/2012/2014 Production and Non Production Servers.
  • Migration of SQL Server 2005 to SQL Server 2008R2, SQL Server 2008r2 to 2012/2014.
  • Setting databases with company policies in place and deploy user data as requested by the application teams.
  • Experience in creating and managing database in Azure platforms.
  • Managed Oracle Databases.
  • Migrated data/databases from Oracle to SQL environments.
  • Installed Oracle tools and drivers on SQL server for creating Linked Servers.
  • Worked on Security Audit Logins , had deployed Audit on Development, QA, UAT environments
  • Worked on installation of MSSQL Server Module on Production and Non Production Servers.
  • Configured AlwaysOn Availability Groups for DR and Reporting.
  • Worked extensively on Data Refreshes from Production to Test environments , automated the whole data refresh process at database level using Power Shell scripts , stored procedures , Backups and SQL Agent jobs without having any performance impact on Production server.
  • Monitored Log shipping/Transactional Replication and trouble shooting of errors.
  • Implemented Database Mirroring and Transactional Replication as a part of DR plan.
  • Rebuilt indexes with different fill factors and update statistics manually.
  • Debug and fine tune the application code SQL for the optimal performance of the database.
  • Experience in Maintaining SQL Server Security including the creation of logins and users, configuring permissions and assigning roles to users as required.
  • Configured Database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions.
  • Used Database Consistency Checks - DBCC commands for database maintenance
  • Detected and Resolved Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor
  • Running Index Tuning wizard for optimal query performance
  • Performed all aspects of database administration, including backups and recovery
  • Handled orphan users while moving databases.
  • Experience in running backups and database refreshes using RMAN.
  • Scheduled weekly jobs and Maintenance tasks for better performance, created the alerts with Database Mail SMTP.
  • Creating and Modifying Tables , T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
  • Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).
  • Supporting and configuring SQL Server Analysis Services (SSAS)
  • Created DB objects such as Tables, Stored Procedures, Views and Triggers as required.
  • Prepared the reports for the day-to-day as well as weekly/monthly purposes
  • Actively participated in determining the database schema , database schema changes, implementation plan for database schema releases in coordination with developers and data models in adherence with Organization policies
  • Proactively monitored , determined and solved issues at SQL/database/server levels

Confidential, Chicago, IL

Sr. Database Administrator (SQL)

Responsibilities:

  • Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
  • Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
  • Design, document, and promote security "best practices", policies, standards and protocols.
  • Migrating application code and objects from development/test environments to production.
  • Working with development and systems teams to perform application and database tuning.
  • Migrating Databases from SQL Server 2005 to SQL Server 2008R2.
  • Setup and maintenance of appropriate database and application monitoring.
  • Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
  • Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
  • Evaluating data modeling, database administration, and database backup and recovery tools and provide recommendations.
  • Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
  • Responsible to Monitor and troubleshooting Log Shipping.
  • Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.
  • Deployed Extract Transform Load (ETL) packages using SQL Server Integration Services (SSIS).
  • Created Linked servers accordingly in between the different servers based on the requirement.
  • Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
  • Worked in Active, Active Passive Cluster environment as a High availability solution.
  • Failover cluster testing and resolution on servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
  • Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
  • Checking Database Health by using DBCC Commands.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Prepared Documentation for the Disaster Recovery plan
  • Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
  • Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
  • Responsible for routine DBA jobs like Backups and Restores.
  • Supported different Oracle Environments like Production, Development and Staging.
  • Performed basic DBA tasks like monitoring, user management, permission management, creating database objects.
  • Experience in running backups and database refreshes using RMAN.

Environment: MS SQL Server 2012/2008R2/2005/2000,T-SQL,SSIS,Lite Speed, BCP, SQL Profiler, Replication, Log shipping, Mirroring, Clustering, Windows XP/2000 and Windows 2003/2008 Server.

Confidential, St. Louis, MO

Sr. Database Administrator (SQL)

Responsibilities:

  • Installed SQL Server 2005, 2008/2008R2 on Standalone and Clustered Environments.
  • Upgraded /Migrated of SQL Server from version r2.
  • Installed Microsoft Service Packs/Patches/Hot fixes.
  • Configured and administered SQL Clusters (Active/Passive, Active/Active), Database Mirroring, Replication and Log shipping.
  • Conducted Backup and Restore of Databases and Schedule Maintenance plans to perform regular Backups.
  • Performed Attach/ Detach, BCP, Import & Exports and Copy Database Wizard.
  • Created Tables, Stored Procedures, Views, Triggers, Cursors and Complex Queries on SQL Server 2005/2008.
  • Worked with Transparent Encryption (TDE), table compression, database compression and merge statements using SQL server 2012.
  • Query Optimization and Performance tuning for optimization like maintaining/creating indexes, Create/Update Statistics, Tuning SQL queries.
  • Analyzed Performance using Performance monitor in order to identify the bottleneck such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
  • Troubleshoot Memory Errors/Query Processing and usage of Memory and resolving errors pertaining to insufficient Memory.
  • Troubleshoot and resolved Blocking, Deadlocks and Long Running Queries.
  • Performed Data Transfer/Migration using Export/Import and Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
  • Deployed and monitored SSIS Packages including upgrade from DTS to SSIS.
  • Utilized DMV’s, Data partitioning and Performance Dashboards reports with SQL Server2005.
  • Configured Snapshot, Transactional and Merge Replication of SQL Server databases and Troubleshoot Replication Problems.
  • Created and Managed SQL Server Logins and Users as per the requirement with specific roles and permissions on production servers.
  • Created various Jobs scheduled & ran jobs and troubleshoot the failed jobs.
  • Provide 24X7 support for the Critical issues like Server Failures and Database inconsistencies like Database Log File full, Suspect, Offline, Missing log files etc.

Environment: Windows 2008 R2, Windows 2008, Windows 2003, SQL Server 2008R2, SQLServer 2008, SQLServer 2005, SQLServer 2000, HP-UX, AIX, Solaris, Oracle9i, Oracle 10g, Foglight, REDGATE.

Confidential, Irvine, CA

SQL Server DBA

Responsibilities:

  • Installation of SQL Server 2005/2008/2008 R2 with latest Service Packs.
  • Worked in Active/Passive Clustered Environment.
  • Implemented the migration of SQL Server R2.
  • Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
  • Experience in monitoring software tools used to monitor the environment effectively.
  • Successfully implemented Database Mirroring in SQL Server 2005 for high availability.
  • Maintain both DEVELOPMENT and PRODUCTION server in sync.
  • Responsible for defining Check constraints, Business Rules, tuning data, indexes, and queries.
  • Running Index tuning wizard and rebuilding indexes for faster query response.
  • Expertise in Security Issues such as creation and granting permissions on various Objects.
  • Exposure to multiple Database systems like MSSQL, Oracle, DB2 and IMS.
  • Involved in Log Shipping.
  • Extensively involved in replication and implemented Snapshot and Transactional Replications.
  • Involved in Monitoring Performance of different production servers.
  • Worked in 24x7 production environment.
  • Working with the end user gathering requirements for the system.
  • Disaster Recovery Plan, Testing and analyzing and continuous update of documentation.
  • Creating Logins and Roles with appropriate permissions.
  • Prepared and documented Backup & Restore Plans.
  • Creating and Maintaining Database Maintenance Plans.
  • RMAN backup & restores
  • Import & Export using oracle utility expdp,impdp
  • Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
  • Involved in analyzing the system for setting up new server and server configuration.

Environment: Windows 2008 R2, Windows 2008,Windows 2003,SQL Server 2008 R2,SQL Server 2008,SQL Server 2005,SQL Server 2000,HP-UX, AIX, Solaris, Oracle 9i,Oracle 10g,Foglight

Confidential

Technical Lead

Responsibilities:

  • Installed, configured and maintained MS SQL fail over clustering for mission critical servers
  • Involved in monitoring the backup jobs and fixed the failed jobs. Created manual Log shipping environments for standby servers.
  • Involved in securing SQL Servers and assign the permissions for users and roles.
  • Designed the logical and physical database design for development projects using Erwin data modeling tool.
  • Involved in improving the server performance using Performance monitor using I/O, memory and CPU counters.
  • Experienced in involving SQL Server performance using index tuning wizards, SQL Profiler and SQL Query Analyzer.
  • Experienced in creating backup strategy for production, test and development servers.
  • Involved in disaster recovery procedures and restore the production databases.
  • Involved in database restore requests and refresh the database between productions, test servers.
  • Created the maintenance plans for integrity checks and optimization for production, test and development servers.
  • Tunes SQL queries and stored procedures to improve the SQL Server performance.
  • Involved in upgrading the instance of SQL Server 2000 to SQL Server 2005 in testing and production environment. Used SQL Server Management Studio (SSMS) for monitoring, troubleshooting and addressing database related issues.
  • Implementing Database Mirroring using high safety with automatic failover for Disaster Recovery. Implemented New Objects according to the Business requirements. Implemented Constraints (Primary Key, Foreign Keys Check and Not Null/Null) and fine tune Indexes on Tables.
  • Developed various reports to validate the data between source and the target systems. Involved in providing security to the reports by restricting various users through Roles. Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries.
  • Configured Log shipping from one production server to the reporting server. Implemented built in log shipping with SQL Server 2000 for disaster recovery server. Creating the Packages for running the jobs automatically good in Implementing SQL Server security and process control.

Key Technologies/Skills: Microsoft SQL Server 2005/2000, DB2, Windows 2003 Enterprise server, Windows 2000 Advanced Server, Visual Source Safe 6.0, Crystal Reports, Business Intelligence Development Studio.

Confidential

Technical Lead

Responsibilities:

  • Planned and Successfully Installed SQL Server 2005 & 2008r2 on the Production and Development Servers.
  • Developing the successful Backup strategies based on Recovery models.
  • Involved in creating Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
  • Involved in DTS/SSIS Package, DTS Import/Export for transferring data.
  • Involved in implementation of replications like Transactional.
  • 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.
  • Ensured proper backup and recovery by maintaining DB2 image copies and recovery JCLs
  • Efficiently carried out DBA responsibilities in planning DB2 version migration activities, in migration phases and in performing post migration tasks.
  • 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.

Hire Now