| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
SQL Server Database AdministratorHouston, TX, 77063 Tell: PHONE NUMBER AVAILABLE Email: EMAIL AVAILABLE LINKEDIN LINK AVAILABLE PROFESSIONAL SUMMARYSeasoned IT professional with 6+ years of expertise in SQL Server Administration and Database Design. Proven capabilities in comprehensive database management, including security, issue resolution, and backup/recovery oversight. Skilled in designing scalable, high-performing database architectures, including Azure cloud solutions. Proficient in automating tasks, developing governance policies, and aligning systems with business needs. Technical leader adept at providing guidance and training to ensure efficient, secure database operations. SKILLS AND TOOLSSQL Server Integrated Services (SSIS), SQL Server Analysis Services (SSAS), Data Encryption, Transparent Data Encryption (TDE), Dynamic Data Masking (DDM), Always Encrypted, High Availability and Disaster Recovery (HADR), Database Mirroring, Log Shipping, Traditional Failover, PowerShell, COBOL, SQL Server Reporting Services (SSRS), Access Control, Auditing, Clustering, AlwaysOn Availability Groups, Replication, T-SQL, SQL Server Management Studio (SSMS), SQL Profiler, Database Tuning Advisor, Azure Data Studio, Azure Portal, Database Mail, SQL Operator, Snapshot, Automation, Normalization, Schema Design, ETL Processes, ServiceNow, JIRA. PLATFORMSWindows OS, Windows Server, SQL Server (2008, 2012, 2014, 2016, 2019), Azure Data Studio, Azure Portal EDUCATION AND CERTIFICATIONMaster of Science, Management Information Systems (MIS) Lamar University 2021Master of Business Administration (MBA) Lamar University 2019Advanced SQL Database Administration Training KiawiTechIT Consulting LLC, TX December 2016 CERTIFICATIONAZ-900: Microsoft Azure FundamentalsDP-300: Administering Microsoft Azure SQL Solutions AREAS OF EXPERTISEComprehensive knowledge of SQL Server deployment, migration, patching, troubleshooting, optimization, maintenance (modeling, High-Availability (HA) and Disaster Recovery (DR)).Skilled in database architecture, performance tuning, backup and recovery, security, and disaster recovery planningSkilled in building complex environments using functions such as Traditional failover clustering, Log Shipping, and AlwaysOn high availability and disaster recovery, migration, backup and restore.Experience in analysis, troubleshooting, investigating, problem solving and communication (oral and written). RECENT PROJECTSMigration of over 100 SQL Server Databases and Managed instances.Managed Projects such as Cloud infrastructure deployment from conception to completion of the project.SQL 2008/R2 Upgrades, SQL 2012 Upgrades, Application Migration and SQL Server Consolidation.Applying windows and SQL Server patches on Production/Non-Production Servers.Configured database backups and restoration, monitored and tuned database. PROFESSIONAL EXPERIENCEFC Services, Houston, TXSQL Server Database Administrator (12/2021 Present)Implement and monitor High Availability solutions, such as Database Mirroring, Log Shipping, Failover Clustering, and AlwaysOn Cluster methods, effectively minimizing downtime and ensuring system reliability.Maintain robust database security, including the implementation of Transparent Data Encryption (TDE), to safeguard sensitive information and ensure compliance with security standards.Successfully upgraded and migrated SQL Server instances and databases from older versions (e.g., 2000/2005 to 2008 R2, 2008 R2 to 2012, 2012 to 2016), ensuring system compatibility, support, and access to the latest features.Automate various database activities by scheduling jobs for backups, monitoring database health, disk space management, and maintenance plans, optimizing system performance and reducing manual intervention.Developed and executed SQL Server maintenance plans and designed efficient ETL packages using SSIS, ensuring operational consistency and reliabilityEstablished a comprehensive backup system, including manual backups, on-demand backups, and scheduled backup jobs, enhancing data protection, and implementing point-in-time recovery measures to mitigate data loss or corruption risks.Amegy Mortgage Capital, Woodland, TXSQL Database Administrator (06/2019 11/2021)Spearheaded 24/7 production database administration, providing unwavering support and proactive monitoring to recognize and resolve database issues promptly, ensuring uninterrupted operations.Configured and managed High Availability solutions, including AlwaysOn Cluster, Traditional Failover Clustering, Database Mirroring, and Log Shipping, ensuring data availability, and minimizing downtime for critical applications.Led database upgrades and migrations, seamlessly transitioning databases from lower versions of SQL to higher versions, both vertically and horizontally, in standalone and clustered environments, ensuring compatibility with evolving technologies.Protectively and regularly monitoring of CPU, Disk I/O, and Memory related bottlenecks, deadlock and carry out similar Troubleshooting.Perform various troubleshooting methodologies to identify and resolve system and user related issues.Orchestrated the migration of databases from on-premises SQL environments to Azure Database in the cloud, showcasing expertise in cloud integration, and developed and implemented a robust Disaster Recovery (DR) plan for data protection and business continuity.Implemented diverse physical and logical backup and recovery methods, including Point-In-Time and Media Recovery, conducted maintenance jobs, and performed daily health check-ups on all databases, ensuring comprehensive data protection, integrity, and system optimization. Cerner Corporation, Kansas City, MOJunior SQL Server DBA (09/2017 05/2019)Responded to customer calls, providing accurate and satisfactory answers to queries while effectively de- escalating situations involving dissatisfied customers, demonstrating strong interpersonal and problem-solving skills.Managed customer complaints by offering appropriate solutions and alternatives within specified time limits, ensuring follow-up to guarantee resolution and customer satisfaction, showcasing a proactive approach to problem resolution.Played a key role in the onboarding process by training new employees on customer management policies, serving as a point of contact for colleagues requiring assistance, and providing technical support on call-related issues, products, and general updates, contributing to team cohesion and knowledge transfer. |
