Clifton Melton
Lawrenceville,GA
Summary
I’m an experienced SQL Server Administrator, who is managing and supporting large and complex SQL Server environments. Manage 250 + SQL Servers Instances of Production, Development, Quality Assurance, and Disaster Recovery environments in MS SQL Server from 2008 R2 - 2019. Strong understanding of RDBMS concepts as well as Data Modeling Concepts. Systematic and organized SQL DBA trained in database management system using a variety of technology platforms such as, SQL Profiler, Extended Event, CDC, TDE, SSIS, SSRS, PowerShell, CMD etc. Skilled in performance tuning, monitoring, and troubleshooting of databases to maintain the integrity and security of critical databases while optimizing performance and availability. Perform capacity planning and offer both long- and short-term solutions to controlling and managing database growth and space management. Experienced in Day-to-day activities such as Agent Jobs, Backups and Recovery, Services, Index, Database growth, health and consistency check, Data maintenance (partitioning, archiving, and purging), issue problem maintenance and management, Security maintenance etc. Working with Active Directory, and experience in managing security, user accounts, and permissions. Strong experience in backup and recovery strategies, disaster recovery, and high availability solutions such as AlwaysOn Availability Groups and Database Mirroring. Provides operational support for enterprise database needs. Manage, audit/monitor, configure and maintain administrative system database instances and environments including application and web servers for optimal performance, security, scalability, and redundancy. Experience in Batch process, Import/Export, Database Monitoring tools and Application support. Experienced in using SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases OLAP. Collaborating with other IT teams, such as application developers, system admin, network engineers, and security specialists, to ensure that all systems are working together efficiently and effectively. Ability to work independently and as part of a team, with effective communication, analytical, and problem-solving skills.
Overview
25
25
years of professional experience
Work History
Senior SQL DBA
McKesson/Allscripts/Altera
04.2012 - 05.2024
- Managed and administered multiple SQL Server databases, including installation, configuration, and ongoing maintenance
- Implemented side by side and In-place Upgrade/Migration of MS SQL server 2012/2014 to 2016/2019, and Migration of databases along with users and logins
- Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN
- Maintaining referential integrity, domain integrity and column integrity
- Creating and maintaining user security, managing users, their security privileges, and accesses
- Configuration and auditing of SQL Server Security in line with compliance and policy, manage server logins-user accounts and passwords along with database object permissions,
- Managing database security, ensuring that patient data is protected and adheres to HIPAA regulations by implementing security policies and procedures, including managing user accounts and access privileges
- Data Encryption Auditing such as transparent data encryption (TDE) or column-level encryption, and ensuring they are properly configured and monitored
- Auditing Protected Health Information (PHI) and Electronic Health Record (EHR) access logs, tracking changes to patient records to maintain its confidentiality, integrity, and availability
- Automating administrative tasks, job scheduling, and monitoring within database environment, such as running stored procedures, executing SQL scripts, and backing up databases
- Created maintenance plans and jobs to achieve maximum performance, such as DBCC, Update Statistics Reorganizing and Rebuilding Indexes, at regular intervals for better performance
- Monitoring database performance using monitoring tools and techniques to identify and resolve performance issues, including optimizing queries, indexes, and other database objects
- Resolving performance related issues to Blocking, Deadlocks and long running queries
- Performance tuning of long running SQL queries and Stored Procedures using SQL Profiler and Query Execution Plans
- Used Change Data Capture (CDC) feature in SQL server to capture all DML activities as requested
- Design and implement comprehensive backup plans and disaster recovery strategies
- Monitoring SQL Server logs to ensure whether backup operations, batch commands, scripts have completed successfully
- Used third party tools called Redgate for monitoring, analyzing, troubleshooting, back up, and SQL Compare tools to compare SQL Database Schemas
- Managed and maintained multiple SQL Server database instances in a Windows Failover Cluster environment
- Implemented and configured AlwaysOn Availability Groups for high availability and disaster recovery purposes on SQL 2016 and 2019 Servers
- Configured and monitored Log Shipping jobs to ensure successful replication of transaction logs between primary and secondary servers
- Monitored Log Shipping and implement and schedule Replication and troubleshooting of errors
- Designed and implemented transactional replication between multiple SQL Server databases, ensuring data consistency and synchronization across distributed environments
- Applied Patches and Service packs, hot fixes to update different versions of MS SQL server
- Created SSIS package to export and import data from SQL Server to Oracle database, also to MS Access, text files and excel files
- Used Virtual Machines (VMs) on Azure IaaS to create and manage SQL Servers and Databases in the cloud and Azure Blob Storage service for storing large amounts of unstructured data.
- Delivered successful database migration projects, ensuring seamless transitions with minimal disruption to business operations.
- Established proactive monitoring solutions that alerted administrators to potential issues before they escalated into major problems.
- Provided timely resolution of critical production issues, minimizing downtime and avoiding potential revenue loss.
- Served as internal consultant for application developers, providing guidance on query optimization techniques that improved application performance significantly.
- Set up and controlled user access levels across databases to protect important data.
- Tested programs and databases to identify issues and make necessary modifications.
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
- Ensured database security with implementation of role-based access control and regular vulnerability assessments.
- Developed and updated databases to handle customer data.
- Collaborated with cross-functional teams to develop custom applications that supported business objectives and met user needs.
- Conducted regular audits of data quality, identifying inconsistencies and implementing corrective actions as necessary.
- Streamlined backup and recovery processes, enhancing overall system stability and availability.
- Installing, Migrating, implementing, upgrading and optimizing performance of databases.
- Designing and implementing various backup and recovery strategies on multiple database environments.
- Recovery of databases with no or minimal data loss.
- Ensuring customers have appropriate maintenance in place including backups, index maintenance, consistency checks and statistics maintenance.
- SQL Server databases/VLDB administration. Configuration, maintenance, and monitoring of SQL Server AlwaysOn and FCI setups.
- T-SQL workload troubleshooting, analysis, and optimization
- Ability to understand and code using T-SQL.
- Lead/assist in planning/installation/configuration of Database implementations, including system software and third-party system tools, applications, and products.
- Routinely analyze procedures and batch code created by others for performance tuning and optimization against highly transactional VLDB environments.
- SSRS, SSAS Installations Routinely perform root cause analysis and identify issues with associated application and technical teams.
- Monitor/maintain environments natively and with third party tools for diagnosing/troubleshooting database and related technologies.
- Played pivotal role in change management for database backend of related application systems.
- Proactive capacity planning of database systems per application and business requirement.
- Analyze and diagnose problems reported to help desk, socializing and escalating support issues where necessary.
- Discuss issues/requirements with client(s) and associated teams. Implement, periodically test and review appropriate data access and security measures, including access control, audit, backup/restore and system rebuild & recovery processes.
- Implement and continuously improve database infrastructure environment.
- Perform software upgrades and new software installation both pro-actively and in response to requests from users of systems, including any necessary patches to database systems and applications to ensure continuing stable and secure operation.
- Active participation in escalation calls or client requirement analysis calls.
- Good working knowledge on ITIL framework: Incident, Change, Release and Problem management. Pro-active analysis, event and incident management ensuring all faults are resolved within agreed SLA.
SQL DBA/Major Accounts Client Manager
Ceridian Corporation
10.1999 - 04.2012
- Installing, configure, monitor, upgrade, patch, and tune MS SQL Server 2008 R2 - 2016 servers
- Implementation of SQL Logins, Roles, and Authentication Modes as a part of Security Policies
- Creating Backup strategies and scheduling them as part of database maintenance plans
- Troubleshoot system issues, monitored scheduled jobs, and set up maintenance plans for proactively monitoring performance of SQL Server databases
- Created Database Maintenance Planner for Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing
- Creating and Modifying T-SQL Stored Procedures/Triggers for validating integrity
- Working with developers on testing and accommodating new functionality of database interfaces
- Created alerts, notifications, and emails for system errors, insufficient resources, fatal database error
- Involved in Building Disaster recovery environment as replica to production servers and created Log-Shipping to manage and support Disaster Recovery and restores
- Maintained database consistency with DBCC and Dynamic Management Views (DMVs) regularly
- Responsible for fine tuning of database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine-tuning Stored Procedures)
- Used Event Viewer, SQL Error Logs and Log File Viewer for monitoring purposes
- Created jobs to monitor resources on various servers to mail Alerts when threshold was reached
- Perform DBA tasks to install, configure, test, maintain, backup, recover, patch, and upgrade
- Tune, administer, and maintain SQL Server databases according to set standards
- Implemented Transactional Replication as part of HA and Log Shipping for DR plan
- Responsible for data migration from Excel, and Flat file to Microsoft SQL Server and vise verse by using BCP and BULK INSERT utilities as well as Extracting, Transforming and Loading of data using Microsoft SQL Server SSIS.
- Maintained client files with sales contracts, records of client interactions, client notes, and other information.
- Handled complaints, provided appropriate solutions, and alternatives within appropriate timeframes and followed up to achieve resolution.
- Built client relationships by responding to inquiries, identifying and assessing clients' needs, resolving problems, and following up with potential and existing clients.
Education
Bachelor of Science - Accounting
Southern Connecticut State University
New Haven, CTAdvanced Certifications - Certified AZ-900: Microsoft Azure Fundamentals
Azure
Advanced Certifications - DP 300: Microsoft Azure Database Administrator
Azure
Skills
- Database Troubleshooting
- Database monitoring
- ETL development
- Stored Procedures
- System Testing
- SQL Proficiency
- Root Cause Analysis
- Patch management
- Backup and recovery
- Python
- Code debugging
- Data Migration
- Disaster Recovery
- Compiling Data
- Process Automation
- Continuous Process Improvement
- Interdepartmental communication
- Data Modeling
- Performance Tuning
- Running backups
- Information modeling
- Query Optimization
- Cloud Database Services
Timeline
Senior SQL DBA
McKesson/Allscripts/Altera
04.2012 - 05.2024
SQL DBA/Major Accounts Client Manager
Ceridian Corporation
10.1999 - 04.2012
Bachelor of Science - Accounting
Southern Connecticut State University
Advanced Certifications - Certified AZ-900: Microsoft Azure Fundamentals
Azure
Advanced Certifications - DP 300: Microsoft Azure Database Administrator
Azure
Similar Profiles
John N. FoxJohn N. Fox
Client Success Executive at Altera Healthcare (a.k.a – HBOC, McKesson, Allscripts and Altera Healthcare)Client Success Executive at Altera Healthcare (a.k.a – HBOC, McKesson, Allscripts and Altera Healthcare)
Vigneshwaran SivaprakasamVigneshwaran Sivaprakasam
Expert Quality Engineer at Altera Digital Health (Formerly Allscripts)Expert Quality Engineer at Altera Digital Health (Formerly Allscripts)
ROHIT PATILROHIT PATIL
Implementation Consultant at Allscripts/Altera Digital HealthImplementation Consultant at Allscripts/Altera Digital Health
Aloba David OluwarotimiAloba David Oluwarotimi
Negotiation Specialist at Discover Financial ServicesNegotiation Specialist at Discover Financial Services
Maaysha HudaMaaysha Huda
Customer Service Representative- Meta AR/VR at Teleperformance (Meta Ar/VR)Customer Service Representative- Meta AR/VR at Teleperformance (Meta Ar/VR)