Sql Server Database Administration

Dawit Sheno

Over * years of experience as a SQL Database Administrator

Experience in SQL, T-SQL, SSRS, SSIS, SSAS, Azure, .NET, PowerShell, jira and Service Now

Specializes in Database Administration, demonstrating hands-on experience in design and development within SQL Server environments, spanning both On-Prem and Azure platforms

SUMMARY

Demonstrates proficiency in installing, configuring, and managing SQL Server versions 2019 through 2012, including successfully executing upgrades from SQL Server 2012 to higher versions.

Applies Service Packs (SP), Cumulative Updates (CU), and hotfixes, ensuring optimal performance and security across SQL Server environments.

Possesses strong analytical and communication skills, fostering effective collaboration within teams and adept at quickly adapting to new technologies and products.

Extensive exposure to Azure PaaS services, including Azure App Service, Azure SQL Database, Azure Functions, and Azure Logic Apps, with expertise in deploying and managing PaaS resources using Azure Resource Manager templates or Azure CLI.

Skilled in monitoring and optimizing Azure PaaS solutions for performance, scalability, and cost-efficiency, resolving issues, and providing technical support.

Proficient in scripting and automation using PowerShell, Azure CLI, or relevant tools to streamline deployment and management tasks, with a focus on scaling and capacity planning to meet workload demands and data growth requirements.

Manages comprehensive database backup and disaster recovery protocols, executing Point-in-Time recovery and scheduling automated tasks for database maintenance activities.

Implements High Availability technologies, including Database Mirroring, Log shipping, and Replication, to fortify database resilience and continuity.

Configures, manages, and monitors High Availability and Disaster Recovery Solutions using AlwaysOn Availability Groups, ensuring continuous data accessibility.

Installs, configures, and maintains Windows Server Fail-Over Cluster (WSFC) setups to reinforce system reliability and fault tolerance.

Designs, develops, and deploys SSIS Packages to automate table migration and create robust Extraction, Transformation, and Loading (ETL) solutions.

ETL ( Extract, Transform and Load ) is a crucial process in SQL Server database administration, for data warehouse and business intelligence.

I have used SSIS for tool for creating ETL packages.

I Extract Data from various sources such as databases, flat files, or webservices.

I Transformed extracted data to fit the operational needs, that includes data cleaning, aggregation, and applying business rules.

I loaded the Transformed data into a destination, such as data warehouse or another databases.

Provisioning and configuration setting up and configuring Azure SQL Database.

Security implementing such as encryption, firewall rules, and access control.

Performance Tuning monitoring and optimization database performance using tools like Query performance insight and Azure monitor.

I have added and worked with NoSQL features such as JSON,XML, key- values stores,graphic databases, and in-memory tables to help non-relational database data.

Formulates backup and recovery strategies aligned with recovery point objectives (RPO) and recovery time objectives (RTO), ensuring data integrity and availability.

Led data migration projects from various platforms to SQL and from On-Premises to Azure utilizing Data Migration Assistant (DMA).

Proficient in generating and managing reports using SQL Server Reporting Services (SSRS) and well-versed in Software Development Life Cycle (SDLC) methodologies, particularly Agile and SCRUM.

Demonstrates competence in IT Service Management processes, including incident, change, configuration, and release management.

Oversees user security and permissions, including creating logins with appropriate roles, user and group account administration, and permission management.

Proficiently scripts Database Consistency Checks (DBCC) and schedules routine execution for optimal database health and performance.

Demonstrates expertise in Database Auditing and Security Configuration, such as Transparent Data Encryption (TDE) and Secure Sockets Layer (SSL).

Utilizes SQL Server Native tools for Query Optimization, Performance Tuning, and Monitoring, ensuring efficient database operation.

Proficient in both DDL and DML query languages, crafting and managing database objects, stored procedures, user-defined functions, indexes, views, and triggers.

Experiences in Conceptual, Logical, and Physical Database design, with a focus on managing large and very large databases in 24/7 operational environments.

TECHNICAL SKILLS

RDBMS/DBMS: SQL Server 2017/2016/2014/2012/2008R2/2008

Database Tools: MS Enterprise Manager, SQL Profiler, Extended Events, SQL Query Analyzer,

Index Analyzer, Backup Server, SQL Agents, SQL Alerts, SQL Jobs, SSRS

ETL Tools: DTS, Integration Services (SSIS)

Design Methodology: UML, Microsoft Visio, Agile/SCRUM

Data Modeling: Erwin, MS Visio

Tools Used: SQL Server Management Studio, T-SQL, Query Analyzer, SQL Profiler,

Replication, Clustering, Database Tuning Advisor, Upgrade Advisor, SQL Configuration Manager and Service Manager, Active Monitor, Performance Monitor, Resource Monitor, SSIS, SSAS, SSRS, Red Gate SQL Compare, IDERA, Ola Hallengren Maintenance Solution and Database Tools

Programming Languages: Transact-SQL, HTML, XML, VBScript, and Java

Operating Systems: Windows 2008, Vista, Windows Server 2012/2016/2019

PROFESSIONAL EXPERIENCE

Freddie Mac January 2022 – Present

Sr. SQL Server Database Administrator

Install, configure, and manage various databases across Production and development environments using SQL Server 2012/2014/2016/2017 to ensure seamless operation and data integrity.

Implement essential Service Packs and cumulative updates across various SQL Server instances to maintain system stability and security.

Orchestrate smooth upgrades of SQL Servers from versions 2012 and 2014 to higher iterations, minimizing downtime and preserving data consistency.

Demonstrate proficiency in data migration processes, facilitating seamless transitions from other platforms to SQL and from On-Premises to Azure using DMA (Data Migration Assistant).

Enforce robust security protocols across Production, Test, and Development environments, safeguarding sensitive data and infrastructure assets.

Utilize Power BI to monitor database performance metrics such as CPU usage, memory consumption, disk I/O, and query performance over time.

Generate custom reports and automate report delivery using Power BI’s scheduling and subscription features.

Use Power BI to create interactive and visually appealing dashboards to showcase key metrics and insights from your SQL databases.

Implement security enhancements for SQL Server using .NET, such as encryption, authentication, and access control mechanisms.

Develop .NET applications to analyze and optimize SQL query performance, identify bottlenecks, and fine-tune database configurations.

Develop .NET applications or scripts to automate routine tasks such as database maintenance, backups, and monitoring.

Monitor all Backup operations meticulously, ensuring timely execution and data integrity.

Engineer Indexes Maintenance Jobs to optimize server performance and enhance database efficiency.

Install, Configure, Manage, and Monitor High Availability and Disaster Recovery mechanisms using HADR Availability Groups, ensuring continuous data availability and business continuity.

Conduct performance tuning activities to optimize database performance, enhancing system responsiveness and efficiency.

Create and maintain diverse logins, meticulously managing security settings to align with required access levels and regulatory standards.

Develop and deploy various jobs to monitor server resources across multiple servers, triggering alerts and notifications when predefined thresholds are reached.

Enhance query performance through meticulous modifications to T-SQL queries, including removal of unnecessary columns, elimination of redundant and inconsistent data, normalization of tables, establishment of efficient joins, and creation of appropriate indexes.

Hold accountable for fine-tuning database performance, troubleshooting issues, managing user administration, memory optimization, and executing DBCC (Reorganize/Rebuilding Indexes and fine-tuning Stored Procedures) for optimal system operation.

State Farm Insurance March 2020 – December 2021

SQL Server Database Administrator

Installed, configured, and administered SQL Server 2019/2016/2014/2012 across development, test, and production environments, ensuring optimal performance and reliability.

Oversaw the seamless upgrade of databases from SQL Server 2012 to SQL Server 2019 and 2014, employing both side-by-side and In-Place methods to minimize disruption and maintain data integrity.

Conducted patching activities, including the application of Service Packs (SPs) and Hot Fixes, to enhance system security and functionality.

Managed security protocols across Production, Test, and Development environments, implementing stringent measures to safeguard sensitive data and infrastructure.

Provided round-the-clock critical production environment support, ensuring uninterrupted operation and swift resolution of any issues.

Demonstrated proficiency in configuring and managing HADR Availability Groups feature within SQL Server 2012/2014, enhancing database resilience and availability.

Configured Log Shipping as a standby database from the production database for reporting purposes, facilitating real-time data access and analysis.

Established and maintained various types of Replications to meet specific business requirements and data distribution needs.

Developed and managed database maintenance plans, including backup schedules, index maintenance, and data integrity checks, to ensure optimal database performance and reliability.

Designed and implemented robust backup and disaster recovery plans, safeguarding data against loss or corruption and ensuring minimal downtime in the event of system failure.

Modified database structures, including tables, indexes (clustered/non-clustered), and constraints (unique/check), to support the development of comprehensive maintenance plans for database monitoring and optimization.

Automated database tasks by creating jobs, alerts, and schedules for routine maintenance activities, streamlining operations, and minimizing manual intervention.

Conducted proactive database monitoring and performance tuning using SQL Server native tools, identifying, and addressing performance bottlenecks to optimize system efficiency.

Monitored server activity and promptly addressed any issues or anomalies to ensure continuous system operation and data integrity.

Applied Dynamic Management Views (DMV) and Dynamic Management Functions (DMF) to analyze and optimize query performance, identifying and addressing long-running queries and related activities.

Aberdeen Asset Management Inc. April 2018 – March 2020

Jr. SQL Server Database Administrator

Installed and administered a four-node cluster Active/Active on Microsoft Windows Server 2012 Enterprise Edition, ensuring high availability and fault tolerance.

Implemented, configured, and monitored HADR Availability Groups on SQL Server 2012 SP2, enhancing database resilience and data protection.

Executed SQL Server service pack and Windows Service pack upgrades, ensuring systems remained up to date with the latest features and security patches.

Conducted regular reorganization/rebuilding and monitoring of indexes to optimize database performance and efficiency.

Played a key role in troubleshooting and fine-tuning databases to enhance performance and concurrency.

Monitored and adjusted performance using execution plans and Index-tuning techniques, ensuring optimal database operation.

Identified and resolved performance issues through comprehensive troubleshooting and database fine-tuning methodologies.

Designed and implemented robust Backup plans and disaster recovery strategies, safeguarding data integrity and availability.

Provided 24/7 Production Database on-call support, ensuring prompt resolution of any database-related issues and minimal downtime.

The Halfaker February 2017 – February 2018

QA Engineer

Facilitated Agile Methodology-driven projects, aligning with Off-Cycle and Enterprise release schedules.

Developed comprehensive Test Strategy, Test Cases, and Test Scripts derived from initial story kickoff design discussions.

Actively engaged in daily stand-up and SCRUM meetings, contributing to progress updates and goal setting.

Collaborated with Business Analysts and Developers to precisely define iteration stories, ensuring alignment with project objectives.

Translated application functionality and testing methodologies across different platforms to ensure consistency and accuracy.

Reported, tracked, and monitored defects meticulously within the defect tracking system, maintaining thorough documentation.

Conducted thorough testing of workflow tasks, validating data and permissions to ensure seamless operation.

Demonstrated proficiency in configuring, creating, and updating/accessing Ticket systems to support business flow requirements.

Established necessary test beds and generated test data essential for comprehensive testing coverage.

Crafted meticulously detailed test cases based on requirements, user stories, or UI snapshots.

Executed System testing and integration testing protocols to validate product functionality and interoperability.

Implemented Security Testing methodologies, employing both Positive and Negative Testing approaches to ensure robust user authentication mechanisms.

Conducted manual schema checks of Oracle databases, utilizing tools like Toad, post-upgrade to validate stored procedures and maintain data integrity.

Leveraged Quality Center/ALM and JIRA platforms for efficient defect tracking, analysis, and documentation.

Utilized SQL queries to extract data from multiple tables within Oracle Database, employing various joins such as Inner and Outer Joins for data retrieval.

Employed SQL Server 2012 to execute SQL queries and validate data integrity, writing and executing test cases against the database.

Developed and executed simple to complex SQL queries to verify database tables for accurate data insertion from GUI interactions.

Conducted Database Integrity Testing by executing SQL statements to validate data consistency and integrity.

Documented comprehensive testing procedures for developers and future testing iterations, ensuring clear guidance and continuity in testing processes.

EDUCATION

Bachelor of Science in Computer Science and Programming - CPU Computer Technology College

Contact this candidate