Database Administrator Resume
VA
SUMMARY
- A certified SQL Server DBA wif (7) years of professional experience in SQL Server Database Administration wif excellent technical knowledge, and troubleshooting experience in Database Design/Modeling, create, manage, deploy reports as well as creating and deploying packages using DTS, and Integration Services (SSIS).
- Backup/Recovery, Monitoring, Performance Tuning, Replications, Always On, Mirroring, Clustering, and writing Stored Procedures, Functions, Triggers, Constraints, and Views.
- Acquired solid working experience in designing and implementing Database Security including Encryption and Transparent Data Encryption (TDE).
- SQL Migration to Azure, Azure Backup, Azure Active Directory
- Substantial knowledge, and strong experience in using third party tools like Red Gate, Idera, Solar Winds, Net, ERWin, Visio and Toad Data Modeler in managing SQL Server database development.
- Very good team player and can work wifout supervision self - motivated and can easily work wif non-technical people.
TECHNICAL SKILLS
Database: SQL Server 201, 2014, 2012, 2008R2, MY SQL, Oracle 11g,19c
Operating System: Windows Server 2016, 2012, 2008 R2, Windows XP, 7, 10
Languages: SQL, T-SQL, HTML
ETL Tools: SSIS/DTSReporting SSRS (SQL Server Reporting Services), VISIO 2007/2010
Data Modeling: Erwin, Visio, Toad Data Modeler, SSDD (SQL Server Database Diagram)
Third-Party Tools: Red Gate, Idera, Spotlight, Visio, Toad Data Modeler, SolarWinds
Networking: Active Directory, TCP/IP, TFS (Team foundation Server)
PROFESSIONAL EXPERIENCE
Confidential, VA
Database Administrator
Responsibilities:
- Installed, Configured, and Managed SQL Server 2014/ 2012/2016/2019 and migrated databases from SQL Server 2008R 2/2005/2012/2014
- Configured and Maintained Four-Node Active/Passive Windows Failover Cluster wif SQL Server 2012 R2 on SAN environment.
- Configured and maintained transactional and peer-to-peer replication and troubleshoot replication issues.
- Configured and administered Always on Availability Group.
- Designed and Deployed SSIS Packages to Export and Import Data from various Databases and Files.
- Performed Database Backup and Point-In-Time Recovery solutions using SQL Server Client and Quest LiteSpeed.
- Managed security and permission of SQL Server.
- Created Database Objects like Stored Procedures, functions, Views, Triggers.
- Managed index usage and fragmentation and updated statistics in databases.
- Involved in troubleshooting and fine-tuning database performance and concurrency and root cause analysis.
- Monitor Event viewer,SQLError logs and Failover Cluster Manager Event Viewer for software and hardware related errors
- Worked on Query optimization and tuning using SQL Server Profiler, Database Engine Tuning advisor, and Activity Monitor and analyzing execution plan.
- Check teh configuration and performance of teh existing databases including data file allocation, index fill factor, fragmentation, and teh impact on system performance. Analyze potential problems (response delay, locking, server down time, etc.) to avoid and optimize.
- Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
- Checked Database Health by using DBCC Commands and DMVS.
- Enforced Policy Based Management at Database Level as well as Table Level.
- Implemented Partitioned Table, Error handling through TRY-CATCH statement, Common Table Expression (CTE), MERGE statements.
- Developed reports using SQL ServerReporting Services (SSRS) and deployed in SharePoint.
- Involved in Data Modelling, Normalization, developing Logical/Physical ER Diagram using Erwin and SQL Server Data Diagram.
- Translated business requirements into technical design specifications and actively supported business users for change requests.
- Provided 24/7 on call support for all teh Production Servers.
- Designing Migration Plans for SQL Azure Project, Identifying On-premises Workload.
- Managing Monitoring Azure Backup Service
- Managing & Monitoring Azure Virtual Machines
- Architecting for High-Availability in Microsoft Azure for SQL workloads wif Availability Sets
Confidential, VA
Database administrator
Responsibilities:
- Installed, configured, and managed MS SQL Server 2016/2014/2012 in Development, Test, and Production environments,
- Migrated databases from SQL Server 2008/2008 R2 /2012 to SQL Server 2014/2016,
- Performed Performance Monitoring and Tuning using windows and SQL performance monitoring tools (i.e., system monitor, task manager, extended events, SQL profiler, activity monitor, DBCC, DTA & DMVs),
- Used DBCC commands, DMVs and DMFs to check database integrity, index fragmentation and statistical updates,
- Administrated teh MS SQL Server security by enforcing security policy.
- Resolved low disk space alerts, connection issues and failed jobs,
- Identified and Troubleshoot CPU, Memory, and I/O bottle necks,
- Configured database mail, jobs, and alerts in all SQL Servers,
- Planed, designed, and implemented backup and restore plans according to company’s Recovery Time Objective (RTO) and Recovery Point Objective (RPO),
- Configured various event driven e-mail notification process in SSIS packages,
- Develop, update, and maintain existing processes and procedures relating to databases
- Maintain, monitor, and improve database status, security integrity, access controls and performance
- Develop, test, and maintain procedures for backup, restoration, and Disaster Recovery for high availability databases
- Provide Database capacity planning and developing and maintaining best practices
- A basic understanding of executing PowerShell scripts and as they related to MSSQL is required.
- Ensuring database integrity, stability, and system availability.
- Ensuring new database schema meets standards for readability and performance.
- Performance tuning new and existing applications.
- Working wif IT Manager to be responsible for database procedures, and related documentation.
- In-depth understanding of application lifecycle management process including planning, design, development, maintenance, and management of multi-terabyte OLTP databases in a 24/7 support environment.
Confidential
Operational SQL DBA
Responsibilities:
- Install, maintain, and troubleshoot all database environments and serves as primary SQL server database administrator
- Monitor, identify, and implement security related updates and patches for SQL Server database systems and Microsoft OS
- Configured SQL Server Agent job and automated alerts and maintenance plan,
- Performed root cause analysis for slow running quires, missing index, outdated statistics, blocking and deadlocking issues,
- Configured and maintain database Always on in Synchronized and A synchronized mode,
- Imported and Export data from/to flat file, access, excel to/from SQL Server databases using SSIS and Import/Export wizard,
- Create and maintain documentation as it relates to database system configuration, mapping, processes, and service records.
- Recommend and execute modifications to database and server environments to improve efficiency and performance.
- Coordinate and collaborate wif various Information Services departments to ensure availability, reliability, and scalability of corporate database environments to meet business demands.
- Configure and maintaining different high availability technologies that are used to support MSSQL i.e., log shipping, transactional, and snapshot replication, mirroring.
- Manage clustered/non-clustered indexes, index rebuilds, partitioning.
- Manage security, roles, logins, and user accounts integrated wif Active Directory.
- Teaming wif technical and business resources to perform implementation and ongoing upgrades.
- Developed parameterized and non-parameterized store procedures, functions, triggers, views and other T-SQL codes,
- Deployed and Automated SSIS Packages using SQL Server Agent Jobs,
- Monitors and maintains physical database structures for data integrity, database performance, quality, recoverability, and maintenance and space requirements to maintain optimal service levels.
- Researches, evaluates, and coordinates software releases, systems upgrades, enhancements, and software updates to ensure that client specifications, industry standards, and best practice guidelines are met.
Confidential
Responsibilities:
- To carry out specialized tasks like foreign currency exchange, issuing of traveler’s and cashier checks and money orders
- Receiving teh working cash for teh day and counting it before teh shift begins.
- Processing cash wifdrawals
- Verifying customers, admitting them to their safety deposit boxes and opening and closing vaults.
- Balancing of teh checks and cash at teh end of every day
- Balancing of teh checks and cash at teh end of every day
Confidential
Responsibilities:
- Receiving teh working cash for teh day and counting it before teh shift begins.
- Processing cash wifdrawals
- Verifying customers, admitting them to their safety deposit boxes and opening and closing vaults.
- Balancing of teh checks and cash at teh end of every day
- To answer queries and to assist customers wif account related issues