| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLE EMAIL AVAILABLEhttps://LINKEDIN LINK AVAILABLEDATABASE ADMINISTRATORSeasoned Database Administrator with 4 years of hands-on experience in managing mission-critical Microsoft SQL Server environments. Proven expertise in all aspects of the database lifecycle, including installation, configuration, administration, optimization, and disaster recovery. Skilled in migrating scripts to production, developing custom stored procedures and ETL solutions using SSIS, and implementing reporting tools like SSRS and Power BI to meet evolving business needs. Committed to leveraging this diverse technical skillset to excel in a database management and development role.Database Administration Database Design / Maintenance SolutionsScript Automation Big Data Project Management AnalysisLanguages: Python, SQL, React, PowerShell, Power BIDatabases: MS SQL, MySQLTools: SQL Server Management Studio (SSMS), MySQL Workbench, GitHub, PowerShell ISE, Azure Data Studio, Visual Studio CodePlatforms: Windows, Azure, LinuxBig Data: ETL, Python, SSIS, SSAS, Power BI, Data Warehouse, Data Factory, Migration, Integration, Dataset, Architecture Design.Soft-Skills:Strong work ethic, professionalism, and attention to detailExcellent collaboration and communication skills, able to work effectively in a multidisciplinary team environmentHighly self-motivated and adaptable to learning and understanding new technologies.Efficient time management and priority setting abilitiesAnalytical mindset with the ability to manage requests and deliver quality resultsPROFESSIONAL EXPERIENCEData & IT Service, Dallas, TX, US 2022- PresentData & IT Services is a leading provider of comprehensive data management and IT solutions that help businesses unlock the full value of their data and technology assets.Database AdministratorDesigned, implemented, and managed enterprise-level database systems, including database architecture, data models, and schema designs, to ensure optimal performance and scalability across Microsoft SQL Server, MySQL, and Azure SQL platformsCreated complex SQL queries, stored procedures, and functions to perform ETL operations from various sources into the database using SQL, Azure Synapse Analytics, SSIS, DTS Packages, SSAS, dimensional modeling (Star Schema, Snowflake Schema), and Power BIConducted regular database performance tuning, query optimization, and indexing to boost system efficiency, reduce response time, and enhance overall database performance using tools like SQL Profiler, Extended Events, Query Store, Index Tuning Wizard (DTA), and Windows Performance MonitorImplemented comprehensive backup and recovery strategies to ensure data integrity and business continuity in case of system failures or disasters, maintaining Recovery Point Objective (RPO) and Recovery Time Objective (RTO)Administered database security measures by enforcing access controls, authentication mechanisms, and encryption techniques to protect sensitive datacontinued
Candidate's Name Page 2PHONE NUMBER AVAILABLE EMAIL AVAILABLECollaborated with cross-functional teams, including software developers and system administrators, to integrate and migrate data to the Microsoft Azure cloudPartnered with cross-disciplinary teams, including developers and system administrators, to integrate and migrate data to Microsoft Azure cloud environmentEmployed SQL Server Integration Services (SSIS) and various ETL tools to create and sustain efficient data integration workflows, facilitating smooth data flow to the data warehouse for analytical purposesMonitored and addressed database issues such as performance bottlenecks, data corruption, and connectivity challengesPerformed regular database capacity planning and devised strategies to manage increasing data volumes and user needsEstablished database monitoring and alerting systems using SQL Server Agent Job and Windows Scheduler to proactively detect and resolve potential issues, ensuring optimal availability and performanceMaintained up-to-date knowledge of the latest database technologies, trends, and best practices, continuously improving skills and knowledgeTechnologies Used: Python, SQL, SSIS, SSAS, SQL Server, MySQL, Azure SQL, PowerShell, Data Warehouse, Power BIUSAID/PMI Funded IRS Project, Addis Ababa, Ethiopia 2019 - 2021The USAID/PMI Funded IRS Project is a malaria control program that provides technical and logistical support to the Ethiopian government to implement and sustain high-quality indoor residual spraying (IRS) campaigns as a key malaria vector control intervention.Database EngineerInstalled and Configured SQL Server Instances in Development, Staging, and Production Environments.Installed and configured SQL Server instances across different environments (development, staging, production)Performed various database administration tasks, such as: Upgrading RDBMS (SQL Server, MySQL) Migrating databases, changing server configuration parameters, Transferring system databases and Managing user accounts and loginsCreated new databases and implemented comprehensive backup strategies, including transaction log backup, differential backup, and full backup, with different recovery levels (simple or full)Documented the databases and configurations for the development, staging, and production environmentsDesigned, implemented, and maintained the internal Extract, Transform, Load (ETL) pipeline, and developed a framework to automate the process using SQL agent jobs, while also suggesting process improvementsDeveloped and tested PowerShell scripts, T-SQL stored procedures, and SQL functions for monitoring and administering databases across different environments (development, staging, production)Performed various database-related activities, such as automation, proactive performance monitoring, system tuning, and query optimizationIdentified and resolved locking and blocking issues, and provided analysis on the causes and their impactsImplemented data reporting systems, including designing and provisioning security accessTechnologies Used: SQL Server, MySQL, PowerShell, SQL, SSIS, JOSN, Power BI, Data WarehouseACADEMIC PROJECTSMigration of Legacy Database to SQL Server 2019 (2019): Led a database migration project, successfully upgrading a legacy SQL Server 2008R2 environment to SQL Server 2019. Conductedcontinued
Candidate's Name Page 3PHONE NUMBER AVAILABLE EMAIL AVAILABLEextensive testing to ensure compatibility and developed a detailed migration plan. Executed the migration with minimal downtime and ensured data integrity throughout the process. Enhanced query performance and implemented indexing strategies to boost overall system efficiency.Technologies Used: SQL, SSMS, SSAS, SSISSchool Data Cloud ETL Migration (2021): Implemented the migration of school administration data to a Azure cloud for a student project. Utilized Microsoft Azure Data Factory to transfer from on-prem data to cloud Azure blob storage. Developed ETL pipelines and performed data transformations, facilitating scalable data processing and enhancing administrative operations in a cloud environment.Technologies Used: Azure Cloud, Data Factory, Azure Synapse Analytics, SSIS, Azure BlobEDUCATIONCertificate in Database Administration, ETL Development, and Azure Analytics(Completed in 2019)Dynamo Data Certified Data Mastery Bootcamp, Dallas, TX, USKey Coursework and Skills Gained: Administering and optimizing SQL Server databases, Developing ETL pipelines and stored procedures using SSIS,Implementing cloud-based data analytics solutions on Microsoft Azure, Hands-on projects applying modern data engineering best practices. |
