| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
SQL SERVER DATABASE ADMINISTRATOR
Bridgeport, CT Street Address | PHONE NUMBER AVAILABLE | EMAIL AVAILABLE | LINKEDIN LINK AVAILABLE
bulule
PROFESSIONAL SUMMARY
Results-driven Database Administrator with over 8 years of experience in managing, optimizing, and
securing large-scale databases in diverse environments. Expertise in SQL Server Database Administration, T-
SQL, performance tuning, database security, high availability and disaster recovery solutions. Proven track
record in database migration and data warehousing. Proficient in Azure SQL Database and AWS RDS for SQL
Server, with hands-on experience in PostgreSQL, MySQL, and Oracle Database Administration.
TECHNICAL SKILLS
Languages: T-SQL, PowerShell, Python, SOQL
RDBMS: SQL Server (2019, 2017, 2016, etc.), Azure SQL Database, AWS RDS, PostgreSQL, MySQL, Oracle
Tools: SSMS, SSIS, SSRS, SQL Profiler, Performance Monitor, Redgate SQL Toolbelt
Cloud & DevOps: Azure Data Factory, Azure DevOps, AWS CloudFormation, Azure Resource Manager
(ARM) Templates, Terraform, Ansible, Docker, Kubernetes, VMware, Hyper-V, Jenkins, Git/GitHub,
Snowflake, Amazon Redshift
Data Management & BI: Data Warehousing, ETL, Data Visualization (Power BI) Data Warehousing, Data
Lakes, Data Visualization (Power BI), Data Mining, Predictive Analytics, Big Data, ETL, Data Pipeline
Development.
CRM & Salesforce: Salesforce Administration, HubSpot CRM
Certifications: Microsoft Certified Azure Database Administrator Associate, AWS Certified Database
Administrator, Salesforce Certified Administrator
WORK EXPERIENCE
SQL Database Administrator | Fairfield Family Care | Stamford, CT | Dec 2022 - Present
Spearheaded the implementation of robust Backup and Recovery Solutions, ensuring alignment
with RPO, RTO, and retention policies. Leveraged SQL Server Management Studio (SSMS) and SQL
Server Agent to automate Database Integrity Checks and Index Maintenance.
Managed complex Database Migration projects to Azure, utilizing Azure SQL Database, Azure Data
Factory, and IaaS/PaaS services. Orchestrated seamless migrations with minimal downtime,
enhancing system reliability.
Optimized SQL Server instances by implementing advanced Query Optimization, Indexing, and
TempDB Optimization techniques. Conducted extensive performance analysis using tools like SQL
Profiler, Extended Events, and Database Engine Tuning Advisor.
Configured High Availability (HA) and Disaster Recovery (DR) solutions, including Always On
Availability Groups, Clustering, and Log Shipping. Ensured continuous availability and quick
recovery during system failures.
Developed and maintained Data Warehousing Solutions, integrating data from various sources into
a centralized repository for comprehensive reporting and analytics. Used SSIS for ETL processes and
SSRS for report generation.
Employed advanced Data Security and Compliance measures, utilizing Transparent Data Encryption
(TDE), Always Encrypted, and Dynamic Data Masking (DDM) to protect sensitive client data.
SQL Server Database Administrator | KiawiTechIT | Texas, US |Feb 2016 - Nov 2022
Led the design and implementation of High Availability (HA) and Disaster Recovery (DR) strategies,
including Database Mirroring, Clustering (WSFC), and Replication (peer-to-peer, transactional).
Improved database resilience and minimized downtime.
Conducted Database Performance Tuning, Query Rewriting, and Parameter Sniffing to optimize
system performance. Utilized SQL Server's Query Store, DMVs, and Dynamic Management Views
(DMFs) for in-depth analysis and troubleshooting.
Migrated on-premises databases to cloud platforms, including Azure SQL Database and AWS RDS
for SQL Server, ensuring seamless transition and scalability. Employed PowerShell Scripting and
SSMS for automation and management.
Collaborated with development teams to review scripts, optimize queries, and ensure best
practices in Database Design and Data Modeling. Provided guidance on SQL Auto Tuning and Index
Fragmentation strategies to maintain peak performance.
Implemented Database Partitioning, Data Encryption, and Auditing techniques to enhance data
security and compliance. Monitored system health using SolarWinds Database Performance
Analyzer and SentryOne, addressing issues proactively.
Worked on Data Science and Machine Learning projects, utilizing Python, Azure Machine Learning,
and Cognitive Services for Predictive Analytics and Data Mining. Integrated insights into business
processes, driving data-driven decision-making.
EDUCATION
University of KwaZulu Natal Durban, South Africa | 2017 - 2020
Bachelor s Degree in Computer Science
KiawiTechIT Academy, USA | 2018 - 2019
Training in SQL Server Administration and TSQL Programming
CERTIFICATIONS
Microsoft Certified Azure Database Administrator Associate (DP-300)
Salesforce Certified Administrator
Microsoft Certified: Azure Data Engineer Associate
SOFT SKILLS
Problem Solving Project Management Communication Skills
Critical Thinking Team Collaboration
MAJOR CONTRIBUTIONS
Led IaaS to PaaS migration projects, leveraging Azure SQL Database and Data Lake solutions.
Re-engineered application logic for integration with Azure Data Factory and Data Warehousing
environments, ensuring scalability and performance.
Drove SQL Server migrations from on-premises to cloud environments, optimizing performance and
reducing costs.
|
