| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Columbus, OH Street Address PHONE NUMBER AVAILABLE EMAIL AVAILABLESUMMARYOver 6 years of experience as a SQL Server Database Administrator with experience on other RDBMS like MYSQL. I possess hands on experience and specialize in overseeing SQL Server installations from 2008/R2 to 2022 working on both standalone and clustered environments, performing core Database Administration/Configuration functions, Production support, Upgrades, Patches, Database and system performance tuning, Backup and Recovery, Cloning/Refresh/Migration of Objects. Experience in ETL processes, data warehousing, and reporting services. Working knowledge in troubleshooting problem queries and implementing HADR (High Availability and Disaster Recovery) Solutions. Advanced experience in application support and database security. Valued for my collaborative nature and adept problem-solving skills.SKILLSLanguages:T-SQL, Windows CMD, PowerShell, Shell ScriptingRDBMS:SQL Server, 2019, 2017, 2016, 2014, 2012, 2008/R2Database Tools:MS Azure, SSMS, SSIS, SSRS, SharePoint, Index Tuning Advisor, Database Engine Tuning Advisor, SQL Profiler, Performance Monitor, Activity Monitor, Always On Availability Groups, DMVs & DMFs, Policy Based Management, Resource Governor, DMA (Data Migration Assistance), Azure Database Migration Service.Third Party Tools:IDERA, Red Gate, Commvault, Jira, ServiceNow.CAREER OBJECTIVESSpearhead strategic IT initiatives, leveraging over 5 years of advanced SQL Server database administration expertise to deploy innovative roadmaps, fortify processes, and institute robust procedures, prioritizing high availability and disaster recovery solutions.Showcase a proven track record of implementing and managing a diverse array of SQL solutions, including intricate configurations like Always On availability groups, log shipping, mirroring, replication, and failover clustering, ensuring optimal system resilience and performance.Exhibit advanced proficiency in SQL server upgrade strategies, database migration, and seamless instance installation, adeptly navigating complex security measures to meticulously manage user access and privileges, with a focus on the principle of least privilege.Specialize in cutting-edge security features such as Transparent Data Encryption (TDE), Always Encrypted, and Dynamic Data Masking, enhancing data protection and compliance adherence.Demonstrate expertise in executing complex processes, ranging from comprehensive disaster recovery solutions to meticulous performance tuning and monitoring, adeptly addressing multifaceted challenges in dynamic environments. Excel in providing unparalleled support for mission-critical databases, leveraging deep insights into on-premises infrastructure to ensure optimal functioning and performance even in the most challenging scenarios.Lead planning and execution of SQL Server upgrades and database migrations, seamlessly transitioning servers from legacy versions to the latest iterations, ensuring continuity and compatibility.Implement robust security protocols, meticulously managing user roles and permissions while leveraging advanced features like Transparent Data Encryption (TDE) and Always Encrypted to fortify data integrity.Exhibit comprehensive expertise and hands-on engagement across all stages of the Software Development Life Cycle (SDLC), contributing to Agile/SCRUM development teams and consistently delivering exceptional results.Optimize SQL code and conduct performance tuning to maximize database efficiency, leveraging sophisticated tools like SQL Server Profiler and Extended Events to monitor and analyze performance metrics.Develop and implement comprehensive disaster recovery plans, conducting regular exercises to validate recovery processes and ensure data integrity and availability.Utilize scripting languages like T-SQL and PowerShell for automating routine database tasks, streamlining administration and management processes for enhanced efficiency.Configure and manage High Availability solutions such as Always-On Availability Groups and Failover Clustering, implementing robust redundancy measures like log shipping and replication to bolster failover support.Administer database backups with meticulous attention to Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO), conducting regular testing and implementing strategies for rapid data recovery in case of emergencies.Collaborate closely with development teams to optimize queries and refine database schema, providing technical support and fostering effective communication across cross-functional teams.Remain abreast of the latest Microsoft SQL Server releases and advancements, actively participating in training and certifications to continually enhance skills and knowledge, ensuring alignment with industry best practices and emerging trends.Work HistorySQL Server Database Administrator, 10/2020 - CurrentRadiant Health Services Columbus, OhioProficiently architect, configure, and oversee Azure SQL servers, databases, and elastic pools, orchestrating seamless data import and export processes to optimize cloud database performance and scalability.Implement proactive measures to ensure high availability, including vigilant standby database monitoring and the establishment of Database Mail and Operator alerts, enabling rapid detection and response to job failures for uninterrupted operations.Expertly manage and administer SQL Server instances across both Infrastructure as a Service (IAAS) and Platform as a Service (PAAS) environments, meticulously optimizing performance to meet demanding business needs.Execute SQL Server installation, configuration, backup, and recovery protocols with precision, safeguarding data integrity and fortifying system resilience against potential disruptions.Spearhead the development of ETL processes and generation of reports using SSIS, SSAS, and SSRS, harnessing the power of Azure Data Factory and Azure Synapse for advanced data integration and analysis, while implementing robust security measures to uphold data confidentiality and integrity.Harness the capabilities of PowerShell scripting to automate critical database administration tasks, enhancing operational efficiency and streamlining workflows.Provide unparalleled technical support to end-users, swiftly resolving database-related issues and ensuring seamless high availability and disaster recovery procedures for continuous service delivery.Develop and implement efficient change management processes utilizing ServiceNow, facilitating streamlined resolution of tickets and user requests, ensuring optimal system performance and user satisfaction.Orchestrated the setup and fine-tuning of database performance, optimizing operations through meticulous configuration of maintenance tasks such as Index Rebuilds and Statistics updates, ensuring peak efficiency and reliability.Led end-to-end planning, installation, and configuration of Microsoft SQL Server versions spanning 2012 through 2019, executing seamless upgrades, migrations, and patch applications during scheduled after-hours database downtimes in complex virtualized environments.Executed flawless migration of database objects including tables, indexes, views, stored procedures, functions, and triggers, resolving discrepancies between source and target databases with precision and agility.Implemented cutting-edge security protocols like Transparent Data Encryption (TDE), dynamic data masking, and Always Encrypted to bolster database security and safeguard sensitive information.Pioneered automation initiatives by designing and implementing maintenance plans for tasks ranging from rebuilding and reorganizing to statistic updates, backups, and cleanup, spanning both on-premises and Azure environments, streamlining workflows and enhancing operational efficiency.Ensured database integrity and security through proactive measures such as validation checks, consistency checks, and leveraging Dynamic Management Views (DMVs), playing a pivotal role in seamless data center migration projects from on-premises to cloud environments.Provided round-the-clock database and application support on-premises, exemplifying unwavering dedication to operational excellence and uninterrupted service delivery.Adhered meticulously to change management protocols, flawlessly executing scripted change requests across diverse environments, while applying optimization strategies to refine SQL code and ensure peak performance.Spearheaded On-Prem to Azure Migration Projects, orchestrating seamless transitions and preserving operational continuity throughout the migration process.Orchestrated a 99% reduction in access-related incidents by meticulously crafting and managing logins/access levels within Azure IAAS and PAAS environments, establishing a fortified and streamlined user access protocol.Elevated operational efficiency through the implementation of automated resource monitoring and tuning strategies, yielding a remarkable 98% reduction in incidents and maintaining an impressive 95% success rate in recovering deleted databases, while executing seamless point-in-time database recovery to ensure uninterrupted data continuity.Significantly augmented database performance by deploying optimized SQL queries and refining indexing methodologies, culminating in a notable 30% reduction in query response times and an overall enhancement in system performance, showcasing a commitment to continuous improvement and optimization.SQL Server Database Administrator, 01/2018 - 10/2020Shammah Health Services VirginiaArchitected and configured Windows fail-over clusters to establish resilient High Availability (HA) solutions, ensuring continuous database availability. Vigilantly monitored and managed Always-On availability groups to uphold seamless database operations in dynamic environments.Executed server decommissioning processes with meticulous precision, guaranteeing seamless transitions and minimizing operational disruptions. Safeguarded database integrity and fortified security measures by expertly managing users, logins, and access permissions.Streamlined operations through efficient task automation using SQL Server Agent and PowerShell scripting, ensuring optimal resource utilization and operational efficiency. Administered database backups using a combination of SQL Server native tools and cutting-edge third-party solutions to ensure data integrity and rapid recovery.Conducted database refreshes and expertly managed data, executing successful upgrades from SQL Server 2008 to SQL Server 2016 while implementing rigorous performance tuning techniques and query optimization strategies to enhance system responsiveness and efficiency.Utilized advanced monitoring tools including Dynamic Management Views (DMVs), Perfmon, Profiler, and other sophisticated utilities to meticulously monitor and tune databases, ensuring optimal performance and scalability.Spearheaded database migration initiatives across SQL servers, managing a diverse portfolio of databases and automating daily backup and maintenance plans to streamline operations and ensure data integrity.Conducted comprehensive database capacity planning, managed data migrations, and executed SQL scripting to optimize system performance and scalability, ensuring seamless integration and compliance with organizational standards.Built and deployed SQL Server Reporting Services (SSRS) to enrich reporting capabilities and enhance data visualization, leveraging PowerShell, IDERA, and Rubrik for streamlined administrative tasks and optimized system operations.Collaborated on SQL Server Integration Services (SSIS) for ETL processes, deploying and troubleshooting stored procedures with precision, while seamlessly integrating IAAS and PAAS Azure services to optimize cloud infrastructure management for scalability and performance.Led migration initiatives, ensuring robust disaster recovery solutions and implementing High Availability and Disaster Recovery (HADR) strategies such as Always On, replication, and mirroring. Skillfully migrated PSQL Databases to MS SQL Server, ensuring seamless transition and compatibility.Implemented strategic solutions to resolve SQL Server issues, delivering a remarkable 20% enhancement in system performance across on-premises and Azure cloud environments, ensuring optimal operations and reliability.Enhanced operational efficiency by an impressive 30% through adept management of IaaS/PaaS database solutions within public cloud environments, driving heightened system performance and generating substantial cost savings.EDUCATIONBachelors University Of BueaCertificationsCertified Microsoft SQL Server Database Administrator (MTA).DECLARATIONThe information provided above is true to the best of my knowledge.Candidate's Name |
