Sql Server Dba
Resume:
Melat Surafel
SQL Server DBA
Bachelor of Computer Science
adzuaj@r.postjobfree.com
Page 1 of 5
SUMMARY
Certified SQL Server DBA with over 7 years of experience in database management, backup / recovery, implementing database modifications, and upgrading databases. Proficient in administering SQL Server v. 2019,2017, 2016, 2014, 2012, 2008r2, 2008, configuring Always On availability group, TDE to encrypt data,performing capacity planning, performance tuning, monitoring, troubleshooting, data warehousing and optimizing databases.
HIGHLIGHTS
• Successfully completed SQL server upgrade and migration from earlier versions to SQL server v.2012 / 2014 / 2016 / 2017 /2019
• Well-versed in performing capacity planning, performance tuning, monitoring, troubleshooting, and optimization of the databases
• Experienced in closely coordinating with developer staff to create, configure and manage various database objects, including tables, indexes, sequences, functions, procedures, packages, triggers, and resolving issues that might impede their ability to get their work done in time
• Performance tuning, storage management, back-up and recovery, managing schemas, report generation and DB clustering technologies
•Strong understanding of Data Warehouse and business intelligence concepts
• Worked with Third-party tools IDERA, SCOM, SentryOne Plan Explorer, Redegdate and Apex
• Expert in analyzing locks, deadlocks, and handling the isolation levels and concurrency effects
• Skilled in performing development of database including creating new databases, converting old databases to new databases, modification of existing databases, and creating reports to meet business needs
• Experience in bigdata tools, Hadoop, Kafka, and data platforms such as Vertica, Snowflake and Storm
• Experience should include performance tuning, storage management, back-up and recovery, managing schemas, report generation and DB clustering technologies
• Excellent in using TDE to encrypt data at rest as well as in transit & to perform real time I/O encryption / decryption IG the data and log filers to protect at rest SCORE CARD
Skills Years of Experience
SQL Server Database Administration 7+
Performance Monitoring / Tuning / Troubleshooting 7+ Availability Groups 5+
Transparent Data Encryption (TDE) 3+
Data warehouse 4+
Technical Expertise:
• SQL Database Administration
• MSSQL Server 2019,2017, 2016,
2014, 2012, 2008r2, 2008
• Always On Availability Group
• TDE
• Performance Tuning
• Performance Monitoring
• Troubleshooting
• Azure
• Snowflake
• Tuning & Query Optimization
• Data warehouse
• ETL tools
• Windows
• Linux
• Mirroring
• macOS
• SSMS
• SSDT
• BIDS
• SSCM
• BCP
• SQLCMD
• DTA
• Profiler
• SSIS
• SSRS
• SSAS
• T-SQL
• SQL
• Query optimization
• Power shell
Educational Background:
• Bachelor of Computer Science,
Stephen F. Austin State University
Professional Certifications:
• Microsoft Certified MSSQL Server
Database Administrator
Melat Surafel
SQL Server DBA
Bachelor of Computer Science
adzuaj@r.postjobfree.com
Page 2 of 5
PROFESSIONAL EXPERIENCE
SQL Server DBA February 2023 – Present
Carollo Engineers
Dallas, TX
Description: Carollo Engineers is an engineering firm specializing in the planning, design, and construction of water and wastewater facilities. administration and maintenance of the databases which include multi- tasking activities such as checking the server health, job schedules, blockers, alerts, replication, log- shipping, deadlocks, disk space management.
Responsibilities
• Installation, administration, and maintenance of SQL Server Instances.
• Performed development of database including creating new databases, converting old databases to new databases, modification of existing databases, and creating reports to meet business needs
• Setup Test, Dev, Staging and Production Environments. Create Users and assign permissions based on the level of database access the user would need.
• SQL Server installation, security setup, database backup\restores, database mail setup, creating .
• Troubleshoot various problems that arise in day-to-day work and fix the issues.
• Monitoring and Performance tuning; Physical Server Level, Database level (DB SETTINGS and options), and query tuning. Creating and maintaining Indexes, configuring memory settings,
• monitoring CPU usage and Disk I/O activity using third party tools
• Rebuilding /monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery Solutions
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Installed, configured, and administered SSRS, SSIS, and SSAS
• Actively participated in installation, upgraded, configurated, and migrated of SQL server in clustered and non-clustered production environments of SQL server
• Coordinated with technical staff regarding planning, implementing, and maintained a production MSSQL database server environment
• Setup and configured SQL Server clustering on window failover clustering service
• Credited for smooth installing and configuring SQL server cluster for troubleshooting major data migration issues
• Involved in troubleshooting and fine-tuning of databases for their performance and concurrency.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
(DTA).
Melat Surafel
SQL Server DBA
Bachelor of Computer Science
adzuaj@r.postjobfree.com
Page 3 of 5
SQL Server DBA August 2019 –February 2023
Atmos Energy, Dallas, TX
Description: Atmos Energy is largest natural gas-only distributor in the U.S., with operations in eight states. They work closely with state and federal regulators to operate a safe and reliable natural gas system across many divisions. In my role as a DBA, my primary responsibility was to manage and maintain the organization’s databases, ensuring they are secure, reliable, and efficient. Responsibilities
• Oversaw day-to-day data management activities including complete database support such as
• installations, configurations, upgrades of SQL Servers, database migration, troubleshooting of
• connectivity, memory issues, query performance, and server-related: auto jobs failures
• Monitored, evaluated, maintained data integrity, including backup strategies, and periodic database consistency checks
• Performed capacity planning, performance tuning, monitoring troubleshooting, and optimization of the databases
• Deployed and Debugged SSIS packages for import, export, and bulk insert data with transformations from various data sources
• Configured always on for providing always on high availability (HADR) in both synchronous and Asynchronous modes as per application requirements
• Create Linked Servers to SQL Servers and other databases such as Oracle, Access, Informix etc.
• Set up High-Availability as part of Disaster Recovery Strategy for the Databases
• Designed / handled High Availability and Disaster Recovery solutions such as Windows Failover Clustering, Always-On, DB Mirroring, Log Shipping, and Replication)
• Responsible for administering SQL Server databases through multiple product lifecycle
• Used TDE to encrypt SQL server and azure SQL database data files at rest
• Headed the upgrading of Microsoft SQL server, failover clustering, log shipping, and replication
• Utilized system monitoring / SQL server profiler to identify bottlenecks, discover slow running queries, performed backup / recovery databases, and implemented database modifications on production servers
• Performed development of database including creating new databases, converting old databases to new databases, modification of existing databases, and creating reports to meet business needs
• Configured / administered Always on availability group with one primary and two secondaries
• Designed / configure large - scale cloud - based migration solution, migrating applications to Azure, IaaS and PaaS with security integration
• Experience new features implemented by azure to reproduce / troubleshot azure end - user issues and provide solutions to mitigate the issue
• Configuring backup and recovery of azure resources. Melat Surafel
SQL Server DBA
Bachelor of Computer Science
adzuaj@r.postjobfree.com
Page 4 of 5
SQL Server DBA October 2017 – May 2019
CIT Bank, Denver, CO
Description: CIT is a division of First Citizens Bank, the largest family-controlled bank in the United States, continuing a unique legacy of strength, stability and long-term thinking that has spanned generations. As a DBA at CIT Bank, my main responsibility was to ensure the reliability, security, and efficiency of the organization’s databases. Daily, working with other IT professionals to ensure that database systems integrate seamlessly with other applications and systems. Responsibilities
• Analyzed department and job-related functionality requirements to align technology priorities with business needs
• Managed SQL Server databases through multiple product lifecycle environments from development to critical production
• Documented and analyzed processes and procedures and adhered to regulatory guidance
• Developed, implemented technical application support / information technology policies, procedures that advanced investment needs, outcomes, and performance measurements to balance continuous innovation with responsible risk-taking
• Assisted in the development of ETL workflows for data warehousing projects, improving data accuracy and implement data transformation rules within ETL processes
• Analyzed, solved, and corrected issues in real-time and gave an end-to-end resolution
• Monitored and evaluated database performance to streamline and improve consistency in service levels
• Ensured all SQL Application servers were properly installed, configured, upgraded, and reducing downtime to zero
• Upgraded Microsoft SQL server as well as performed failover clustering, log shipping, replication, using System Monitor and SQL Server Profile
• Configured always on for providing always on high availability (HADR) in both synchronous and Asynchronous modes as per application requirements
• Designed / handled High Availability and Disaster Recovery solutions such as Windows Failover
• Clustering, Always-On, DB Mirroring, Log Shipping, and Replication)
• Uncovered / resolved the issue of mission-critical of high usage of system CPU, disk, blocking issues
• Uncovered / resolved the issue of mission-critical of high usage of system CPU, disk, blocking issues, transaction per / sec, memory involved in performance monitoring of memory, processor, and disk I/O
• Experienced in closely coordinating with developer staff to create, configure and manage various database objects, including tables, indexes, sequences, functions, procedures, packages, triggers, and resolving issues that might impede their ability to get their work done in time Melat Surafel
SQL Server DBA
Bachelor of Computer Science
adzuaj@r.postjobfree.com
Page 5 of 5
SQL Server DBA August 2016 – August 2017
HP, Palo Alto, CA
Description: HP Company, American manufacturer of software and computer services and a major brand in the history of computers and computer-related products. My responsibilities as a DBA were associated with a Data Center Migration (DCM) and administering databases, overseeing installation, configuration and upgrades.
Responsibilities
• Produced high-standard database solutions to meet stability, reliability, and performance metrics
• Documented and analyzed business reports for prompt communication, follow-up, and ongoing support
• Administered, supported, monitored databases by proactively resolving database issues, and maintaining servers
• Supported multiple concurrent projects enabling delivery efficiencies and technical resolution
• Developed custom database objects, stored procedures, and delivered application support
• Maintained complex T-SQL queries, views, and stored procedures in a multi-database environment with little supervision
• Exported and imported data from flat files and row files using DTS and SSIS
• Leveraged exceptional professionalism / field expertise to set up, maintain, support SQL server high availability & disaster recovery solutions such as always on availability groups, failover clustering, mirroring, log shipping, and replication
• Designed and implemented database backup and restore policies and request procedures
• Worked with developers to improve referential, domain, and column integrity using constraints
• Implemented and tested point - in - time recovery restores of production databases on test servers
• Implemented SQL server security auditing, hardening, and remediation
• Wrote / coded logical and physical database descriptions, specifying identifiers of database to management systems
• Automated routine maintenance tasks, including routine database refresh requests using SQL server agent, maintenance plans, and PowerShell scripts
• Analyzed and designed source systems, business requirements and identified business rules for building the data warehouse.
Contact this candidate