Sql Dba Resume
Suitland, MD
SUMMARY
- I am an experienced IT professional who is highly competent and motivated owning, tracking and resolving issues related to the databases.
- I am a Certified SQL Server Database Administrator with more than 6 years experiences and OCA certified Oracle Database Administrator.
- I have experience working as a SQL Server Database Administrator and looking for a Database Administrator job.
- As a Database Administrator I ensure databases are secure and performing properly. I monitor database activities and performance, perform upgradation and migration, users access, determine user needs, design databases, modeling data.
- I have experience to design, configure and maintain HA/DR solutions (AlwaysOn, FCI, Log Shipping, Replication) and troubleshooting large databases.
- I have experience in Microsoft Azure Cloud technology. I am able to work with other IT professionals and managers to ensure database integrity and security are kept up with.
- I’m looking for a Database Administrator position that will allow an individual with exceptional technical and communication skills to benefit the company.
- More than 6 years of technical experience in Database Administration of Microsoft SQL Server 2016/2014/2012/2008 R2/2008/2005 in Production, Development and Test in Clustered, AlwaysOn, Stand - alone Server and Azure Cloud Environment.
- Expertise in Installation, Server Configuration, Troubleshooting, Maintenance and Administration of SQL Server 2005, 2008 R2, 2012, 2014, 2016 updating with hotfix and service packs.
- Experience on High Availability/Disaster Recovery(HA/DR) Solutions Failover Cluster, AlwaysOn, Replication, Log Shipping and Mirroring.
- Strong experience to support data migration from On-Premises SQL Server to SQL Server on Azure Virtual Machine (IaaS) and Azure SQL Databases (DBaaS) using different tools like DMA, SSMW, Backup and Restore, generate Scripting.
- Experienced to use Native Tools and Third Party Tools for monitoring, troubleshooting and solving Performance related problem.
- Used SQLIOSim for simulate SQL Server activity (on a disk subsystem) and SQL Query Stress (load test individual queries).
- Experience in analyzing locks, DeadLocks and Handling the Isolation Level.
- Resolve Lock, Block, DeadLocks/Long running queries, High CPU & Memory and managing TempDB.
- Design and develop database maintenance plans and jobs for Database monitoring, maintenance and automation.
- Monitoring Server Activity, Error Log, space usage, Server and Database health, backup verification, cleaning history and problem solving as needed.
- Actively involved in SLAs and management of Change Control Requests.
- Configured SMTP Server for DB Mail setup and received Alerts for Threshold values.
- Experienced in System Databases configuration and Management such as TempDB, MSDB and Master DB.
- Managing Linked Servers between SQL servers and other data sources using ODBC, OLE DB drivers.
- Handled multiple SQL Instances on Cluster built on SAN using RAID levels.
- Extensively worked on Active-Active and Active-Passive Clustering
- Extensive experience in implementing High Availability Solutions like Replication, Log shipping, Clustering and Mirroring on physical and virtual machines.
- Expertise in implementing Security Management: SQL Servers and Databases, users, column and row level security, Data Encryption, configure Transparent Data Encryption (TDE) on server and Database level and data masking.
- Auditing of database for user’s transaction, login and removing orphan users.
- Proficient in Active Directory and managing Security Group.
- Designing the Database Backup and Recovery plan, and test the Database Backups.
- Capacity planning and implementing disaster recovery solutions, Managing Storage, Backup, Restore, Point-in-Time Recovery with RTO, RPO and SLA.
- Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
- Creating Conceptual/logical/physical data model level using Erwin tool.
- Experience in creating Constraints, Tables, Indexes, Views, Stored Procedure, Functions, Triggers and Dynamic SQL queries.
- Experienced in implementing Side by Side Migration and in-place upgrade of MS SQL Server 2005/2008 to 2012 and 2012 to 2014/2016
- Experienced in migrating data from Oracle 10g to SQL Server 2012/2014.
- Involved in data migration from On-Premises Server to Azure SQL Databases (DBaaS).
- Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, Bulk Insert, BCP
- Deployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources.
- Excellent Problem Solving Skills, Communication, Strong troubleshooting and Organizational skills.
TECHNICAL SKILLS
Databases: SQL Server 2017/2016/2014/2012/2008/2005/ MS Access and Oracle 10g and 11g R2
Database Performance & Troubleshooting: Activity Monitor, DMVs, Extended Event Lite, Built-in Reports, Database Tuning Advisor, SQL Server Profiler, Query Execution Plans, PerMon, Counters, System Objects like sp who, sp who2, sp lock, etc., DBCC, Windows Server Performance Monitor and custom sp.
Third Party Tools: DDBoost, EMC Appsync, RedGate, WebEX, SolarWinds, idera diagnostic manager, SentryOne, Ola Hallengren.
Upgrade/Migration: MS SQL Server to SQL Server, Oracle to MS SQL Server, MS SQL Server to Azure Database and SQL Server on Azure VM
Operating System: Windows Server 2016, 2012R2, 2008, 2003 and UNIX/Linux.
Hardware/Storage: SAN, NAS, RAID, ISCSI
Virtualization Technology: VMWare, Virtual Box, Hyper-V, V-Spare, vCenter server, Azure VM
Cloud Technology: Manage, Configure and Migrate from MS SQL Server to Azure database & SQL Server on Azure Virtual machine.
Languages: SQL, T-SQL - DDL,DML,DCL,TCL, C#, Python
ETL/Data Warehouse Tools and Reporting Tools: SSIS/DTS, BCP, Enterprise Reporting, Report Builder 11.0/12..0/15.0/ , Power BI
Networking & Security: Active Directory, Setup TCP/IP, Setup DNS Server, Create User and Authentication, Remote Desktop, SSL, OLEDB, ODBC.
Data Modeling Tools: Erwin, Toad Data Modeler, MS VISIO
PROFESSIONAL EXPERIENCE
Confidential, Suitland, MD
SQL DBA
Responsibilities:
- Install, configure, patch, Administer and troubleshoot SQL Server 2016, 2014, 2012 in Development, Test, UAT, and Production environment.
- Configure, troubleshoot and manage HA solutions on AlwaysOn Availability Group using SQL Server 2012/2016 with synchronous Commit automatic-failover mode. .
- Manage and troubleshoot four node cluster; three Active/Active and one Active/Passive on Microsoft Windows Server 2012/2014 and Sql server 2012/2014 Enterprise Edition on SAN environment. (OLTP - 2012, OLAP - 2014)
- Configuring, troubleshoot & Managing Log shipping on MS SQL Server 2012.
- Cloud/Azure experience includes Microsoft Azure Services, IaaS, Migrated SQL Server On-Premise Databases to SQL Server on Azure VM, setup Development and Test environment on Azure Virtual Machines (IaaS).
- Monitor performance and troubleshoot issues and activities using different kinds of native and third party tools like iDera, DDBoost, Activity Monitor, Standard Built-in Reports, DMVs, Database Tuning Advisor, SQL Server Profiler, Query Execution Plans, PerMon, Counters, System Objects like sp who, sp who2, sp lock, etc., DBCC, Windows Server Performance Monitor.
- Resolve Lock, Block, Dead locks/Long running queries, High CPU, I/O, Memory bottlenecks using DMV, DBCC, Standard Report, custom SP, queries and managing TempDB.
- System performance monitoring by I/O, processes wait-time, response time, physical memory, network bandwidth with traffic, connection conjunction, and space availability, MAX dop Index Tuning, Index Rebuild and Reorganize.
- Developed, maintained and implemented database backup and recovery plans by using RTO and RPO in SLA level for Production, Development, Test, and UAT environments.
- Expertise in Database Backup and Recovery procedures by using Native and third-party tools such as EMC Appsync and Ola Hallengren.
- Disaster Recovery designing and implementation. Planned, Developed and Manage Databases Refresh strategies, maintenance plan jobs, monitoring and troubleshooting jobs.
- Work with developers for tuneup T-SQL Scripts and tuning up database and tuning up application performance.
- Upgraded & Migrated SQL Server 2012 instances to SQL Server 2014 and 2016.
- Configure, Manage and Troubleshoot Linked server to enable the SQL Server Database Engine to execute T-SQL commands in another instance of SQL Server, or database against OLE DB data sources outside of the Database and Instance.
- Automate and enhance daily administrative tasks including space management, object alteration, Database Refresh, Scrubbing classified data.
- Write SQL/T-SQL Scripts, Stored Procedures, Triggers, Functions and setup jobs for various Automation Purposes.
- Perform Table partitioning, monthly & yearly data Archival activities.
- Capacity planning for Database and generating the Database growth.
- Apply patches such as SP, Hot Fix, Featured Pack, Cumulative updates.
- Defining SQL Server standards for HA based on Applications requirements.
- Responsible for securing SQL Server environment, involved in invoke, deny and granting permissions on various Objects, created the guide line to secure SQL Servers.
- Participate in the 24/7 rotational On-Call schedule
Work Environment: Windows Server 2016,2012, SQL Server, 2016, 2014, 2012, Azure Cloud, AD (Active Directory), CyberArk, Idera, Data Domain, ControlM, Ola Hallengren, DDBoost, EMC Appsync, Beyond Compare, SQL search 2, TortoiseGit, Netapp, Royal TS, Entrust, Viewfinity, Emcopy, Splunk, Outlook, PowerShell, Service-Now, Loopup, Visio, SharePoint, Cisco, WebEx, SolarWinds, My SQL, Oracle, ETL Processing.
Confidential, Charlotte, NC
MS SQL DBA
Responsibilities:
- Configure, manage and troubleshoot cluster Active/Passive on Microsoft Windows Server 2012/2014 and Sql server 2012/2014 Enterprise Edition on SAN environment. (OLTP - 2012, OLAP - 2014)
- Handle multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
- Monitoring Event Viewer, SQL Error logs and Log File Viewer for cluster, software and hardware related errors.
- Installed, configured, monitor, troubleshoot and Administer SQL Server 2014, 2012, 2008r2 in Development, Test, UAT, and Production environment.
- MySQL 5.1.23/5.5.6 databases to SQL Server 2012/2014. configure, manage and Migrate deploy, migrate, upgrade SSIS projects and packages from SQL Server 2008 R2 to 2012.
- Configure, monitor, troubleshoot and maintenance Transactional and Snapshot Replication.
- Performed performance tuning activities in different aspects using different tools like Execution Plan, SQL Profiler, Performance Monitor, Index Tuning, Index Rebuild and Reorganize, setup automated jobs for index management tasks, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
- Resolve Deadlocks/Long running queries. Proven working experience in Query Optimization, Indexing, and Troubleshooting SQL Server related issues.
- Designed, implemented and maintained database backup and recovery plans by using RTO and RPO in SLA level for Production, Test, UAT and Development environments including mission critical databases.
- Configure and manage Reporting Servers, Deploy, migrate, upgrade Reports, Reporting Server.
- Supports day to day operational activities for the database platform like service requests, email alerts and tickets for potential problems.
- Automate and enhance daily administrative tasks including space management, object alteration, database backup and recovery.
- Responsible for securing SQL Server environment, involved in creation and granting permissions on various Objects, created the guide line to secure SQL Servers.
- Capacity & DR planning for Database and generating the Database growth.
- Export & Import data from Flat file (CSV, Excel) to SQL Server Database using EXP/Import.
Work Environment: Windows Server 2012, 2008r2, IIS 7.5, SQL Server, 2014, 2012, 2008r2, AD (Active Directory), SQL, SQL SentryOne, PagerDuty, notepad++, Entrust, Robocopy, wepresent, Service-Now, TFS, Visio, SharePoint, WebEx, SolarWinds,, My SQL, ETL Processing.
Confidential, Livonia, MI
Database Administrator - System DBA
Responsibilities:
- Installed, Configured, troubleshoot and maintain SQL Server 2005, 2008 R2, 2012 in Development, Test, and Production environment.
- Configure, monitor and maintenance of Log Shipping and Mirroring in sql server 2008r2 and 2012
- Database backup plan, database health check, rebuild or reorganize indexes, database update statistics, history or maintenance clean up tasks (automated).
- Recovered the databases from backup in disasters. Implemented Point-In-Time Recovery solutions.
- Upgraded SQL Server 2005, 2008r2 to 2012.
- Database Mail configuration and alert setup and notification for status.
- Monitor the indexes usage, update statistics at regular intervals for better performance.
- Performance Tuning - Execution plan, Performance Monitor, Activity Monitor, Extended Events, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
- Installed, configured, troubleshoot, managed and administrator Oracle Databases in development, testing and production environments.
- Developed or modified Oracle backup and recovery scripts. Using Oracle 10g RMAN Implement Oracle backup and disaster recovery.
- Responsible for database security and also prevented data loss.
- Identifying and escalating immediately any risks to the database service.
- Involved in the design of physical and logical database, data modeling, and performance tuning.
- Handled errors using exception handling.
Work Environment: SQL Server 2005, 2008r2, 2012, IIS 7.5, 8.5, Oracle 10g, Windows Server 2003r2, 2008r2, ASP, ASP.net, Java, ETL and AD (Active Directory), ERWin, Expand-IT, Netapp, Financial Application, JIRA, VM Server, Spotlight, RedGate.
Confidential
Software Engineer
Responsibilities:
- Involved in the full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
- Developed Packages, Procedures and Functions in Oracle 9i.
- Designed Data Model Diagram using Designer 10g.
- Created views, table, sequences, indexes and synonyms database objects.
- Created partitioned tables and indexes.
- Tuned packages to improve performance of the application.
- Developed Oracle FORMS and REPORTS for financial reporting using Oracle 10g.
- Created Designed Documents and technical documents.