Efficient administrator eager to leverage knowledge in cloud-based database management systems. Skilled in database security, backup and recovery with good understanding of automation and containerization tools. Team-oriented with stong work ethic.
Overview
10
10
years of professional experience
Work History
Sr. SQL Server DBA
Bank Of America,
07.2019 - Current
Designed and implemented TSQL queries for reporting and complex solution development.
Implemented system enhancements to design and develop solutions to address problem reports.
Install, configure, and upgrade database management systems (DBMS), such as SQL Server.
Create and maintain database instances and schemas.
Monitor database performance, including query optimization and tuning for optimal response times.
Implement best practices for database design and development.
Develop and enforce database security policies, ensuring the protection of sensitive financial data.
Manage user access and permissions, including role-based security.
Monitor and audit the database for potential security breaches.
Implement robust backup and recovery strategies to ensure data availability and business continuity.
Regularly test and verify backup and recovery procedures.
Plan and execute recovery in the event of data loss or system failures.
Set up and maintain high availability solutions such as clustering, database mirroring, or AlwaysOn Availability Groups.
Develop and test disaster recovery plans to minimize downtime in case of unforeseen disasters.
Set up and maintain high availability solutions such as clustering, database mirroring, or AlwaysOn Availability Groups.
Develop and test disaster recovery plans to minimize downtime in case of unforeseen disasters.
Develop and test disaster recovery plans to minimize downtime in case of unforeseen.
Collaborate with application developers to assist in database design and performance considerations.
Review and optimize SQL queries, stored procedures, and triggers for efficient data retrieval and processing.
Automate routine database maintenance tasks using scripts and scheduled jobs.
Implement monitoring and alerting systems to proactively identify and address database issues.
Assess and plan for future database capacity requirements.
Scale the database infrastructure to handle increased data loads as needed.
Maintain comprehensive documentation of the database environment, including configurations, security policies, and backup procedures.
Generate regular reports on database performance and health.
Participate in an on-call rotation to provide 24/7 support for critical production databases, ensuring minimal downtime.
Interact with database software vendors to stay informed about updates, patches, and new features.
SQL DBA
Citgo Petroleum Corporation
01.2017 - 04.2019
Installing, configuring, and upgrading database management systems (DBMS) as needed.
Monitoring and optimizing database performance to ensure efficient data retrieval and processing.
Developing and implementing backup and recovery strategies to ensure data availability and business continuity.
Managing database security by controlling user access, permissions, and implementing security policies to protect sensitive data.
Setting up and maintaining high availability solutions like replication, clustering, or failover mechanisms to minimize downtime.
Performing routine database maintenance tasks, such as data cleanup, data migrations, and data archiving.
Identifying and resolving database-related issues, such as performance bottlenecks or data corruption.
Maintaining comprehensive documentation of the database environment, including configurations and security policies.
Creating scripts and scheduled jobs to automate routine database tasks.
Collaborating with development teams to assist in database design, optimization, and performance considerations.
Ensuring that the database systems comply with industry regulations and standards.
Followed standard practices for migrating changes to test and production environments.
Set up and controlled user access levels across databases to protect important data.
Set up and controlled user profiles and access levels for each database segment to protect important data.
Conducted tests to identify issues and make necessary modifications.
Implemented security measures to protect vital business data.
SQL DBA
Memorial Hermann Health System
01.2014 - 12.2016
Install, configure, and maintain database management systems (DBMS) used for storing patient data, healthcare records, and other critical information.
Implement and enforce database security measures to ensure the privacy and protection of patient data, in compliance with healthcare regulations like HIPAA (Health Insurance Portability and Accountability Act)
Develop and manage robust backup and disaster recovery strategies to ensure the availability and integrity of healthcare data in case of emergencies or system failures.
Monitor and optimize database performance to ensure that healthcare professionals have fast and reliable access to patient records and other healthcare data.
Collaborate with healthcare IT teams, including application developers, to support the integration of database systems into healthcare applications.
Maintain comprehensive documentation of the database environment and ensure that all database operations adhere to healthcare compliance standards.
Develop scripts and automated processes to streamline routine database maintenance tasks.
Develop and test disaster recovery plans specific to healthcare data to minimize downtime in emergencies.
Education
Bachelor's Degree -
Kingston University
London Kingston
01.2011
Skills
Over 6 years of IT experience in Microsoft SQL Server Database Installation, Configuration, Administration, Maintenance, Performance Tuning, Backup/Restore and disaster recovery procedure experience in SQL Server 2017/2016/2014/2012/2008R2/2008
Having hands on experience migrating scripts in a production environment and extensive experience in creating and modifying stored procedures, triggers, cursors and functions to meet business requirements
Experienced in SQL Server Reporting Services Installation, Configuration and Maintenance using Visual Studio and Reporting Services
Experienced in implementing SQL Server Security and object permission like maintaining creation of users, configuring permissions database authentication modes and assigning roles of users
Expertise in implementing different types of high availability and disaster recovery mechanisms like replication models, log shipping, database mirroring and clustering
Worked on Clustering and server consolidation, troubleshooting production issues and raising high availability
Sound knowledge stored procedures, Indexed views, User Defined Functions (UDL), Triggers Distributed Queries and Common Table Expressions
Expertness in trouble shooting database issues like space issues, deadlocks, performance and blocking