Sql Server Production Support
Resume:
TEWODROS DESTA
Personal details
TEWODROS DESTA
************@*****.***
Alexandria, VA
linkedin.com/in/tewodros-desta-
b751ba175
Skills
Microsoft SQL Server
T-SQL
SSIS
SSRS
Database Security
Database Encryption
Replication
Mirroring
Log shipping
Always On
Excellent problem-solving abilities
Good team player
Ability to learn new emerging
technologies and adapt quickly
Profile
Resourceful SQL Server DBA/Production Support DBA with over 8 years of experience in database administration and 2 years of experience in SQL Server Developer, proficient in installing, configuring, and maintaining SQL Server environments, including versions up to 2019. Expertise in database security, TDE encryption, SSRS, SSIS, performance tuning, and high availability solutions such as Always-On and failover clustering. Successfully migrated SQL Server instances and developed various SSRS reports and SSIS packages. Skilled in automating database refreshes and resolving security threats, ensuring optimal database performance and security.
Education
BS Biology Aug 2010 - Dec 2012
Radford University, Radford, U.S.A
Associate's degree in information systems
technology
Aug 2005 - Jan 2008
Northern Virginia Community College, Alexandria
Employment
SQL Server DBA/Production Support DBA Aug 2021 - Present Dignari LLC, Washington
Involved in the migration of SQL Server Instances from SQL Server 2012 to SQL Server 2019 to enhance system performance.
Engineered, configured, and maintained SQL Server 2019 across development, testing, and production environments to ensure optimal operation.
Enhanced server and database security protocols, including the implementation of Transparent Data Encryption (TDE). Installed and configured SQL Server Reporting Services (SSRS) to facilitate comprehensive reporting capabilities.
Developed and managed jobs and maintenance plans that automated regular backups, rebuilt indexes, and monitored server health through alerts and notifications.
Formulated diverse maintenance plans that effectively monitored database health and performance.
Conducted rigorous database and SQL performance tuning initiatives to elevate efficiency.
Created SQL Server Agent jobs for nightly data import processes, ensuring reliable data integrity.
Tracked the performance of scheduled jobs to promptly identify and address issues.
Executed regular data imports from the National Finance Center to keep employee records up-to-date within the Department of Homeland Security. Imported Investigation documents from OPM into the ISMS database to facilitate efficient information flows.
Orchestrated the export of investigation decisions from the ISMS database to OPM, ensuring compliance and reporting accuracy.
Developed and deployed various reports for DHS components utilizing SQL queries and stored procedures for data analysis.
Managed access to the reporting server, granting permissions to users from different agencies as per management requests.
Conducted user account deactivation for SQL Server Reporting Services to maintain security and compliance standards.
Championed the development of SSIS packages from various data sources including SQL Server Database, Flat files, CSV, Excel, and other ODBC/OLE DB sources.
Assessed and processed Data Change Requests to rectify data discrepancies in the database back-end.
Crafted custom queries to respond to data calls, providing detailed reports to upper management.
Facilitated interconnections with internal and external information systems to streamline data flow.
Reported on program progress, highlighting issues and resolutions to stakeholders.
Compiled and delivered weekly status updates and ad hoc reports. Supported the Program Manager in overseeing contract performance and compliance.
SQL Server DBA/Production Support DBA Jun 2019 - Aug 2021 ProSol Inc, Washington
Monitored the health and performance of SQL databases, implementing strategies for operational excellence.
Created SQL Server Agent jobs to automate nightly data imports, ensuring timely updates.
Evaluated the performance of all scheduled jobs to preemptively identify potential issues.
Facilitated data imports from the National Finance Center bi-weekly to ensure accuracy of DHS employee information.
Imported investigation documents from OPM into the ISMS database to support data integrity.
Exported investigation decisions from the ISMS database to OPM to fulfill reporting obligations.
Developed SQL queries to generate SSRS reports per component requests, enhancing data accessibility.
Managed the reporting server, providing access permissions for users across agencies according to management's directives.
Conducted user account deactivations within the Reporting Server to maintain compliance with operational standards.
Executed mass inactivation of inactive Report Server users based on 45- day non-usage criteria.
Received and logged Data Change Requests via SharePoint from users across all components to ensure systematic processing. Processed Data Change Requests to address data anomalies within the database back-end.
Crafted custom queries to meet data inquiries, supplying comprehensive information to upper management.
Facilitated interconnections with various internal and external information systems to enhance data interactions.
Compiled reports on program progress, addressing issues and resolutions for continuous improvement.
Delivered weekly status reports and various ad hoc reports to stakeholders. Assisted the Program Manager in managing overall contract performance and compliance.
SQL Server DBA/Production Support DBA Feb 2015 - Jun 2019 Lightspeed LLC, Washington
Installed, configured, and administered SQL Server 2008R2/2012/2014 in both production and development environments to ensure robust system performance.
Proactively monitored CPU, Disk I/O, and memory-related bottlenecks, addressing potential performance issues systematically. Employed various troubleshooting methodologies to identify and rectify system and user-related issues efficiently.
Created jobs, alerts, and notifications for critical system errors, resource insufficiencies, and security breaches, guiding task assignments and tracking. Oversaw monitoring and management of tablespaces and data file growth, ensuring efficient storage utilization.
Analyzed tables and schemas, collected system statistics, and rebuilt indexes to maintain optimal database performance.
Maintained and monitored production SQL servers, ensuring they are updated with the latest rollup hotfixes and service packs. Configured Windows Server 2014 failover clustering for enhanced availability and disaster recovery solutions.
Designed and implemented log shipping, mirroring, and replication from primary to secondary sites to support mission-critical applications. Executed migrations of multiple databases, SSIS packages, SSRS reports, and SSAS cubes between different SQL versions using both in-place and side-by-side migration methods.
Transitioned numerous production databases, jobs, packages, reports, linked servers, logins, and other SQL objects to newer SQL server versions. Collaborated closely with application, development, and infrastructure teams for migration planning and meeting new application requirements/releases. Conducted performance tuning and optimization of stored procedures and queries for maximum efficiency.
Managed database maintenance tasks, including index fragmentation, DBCC operations, and performance monitoring for optimized query efficiency. Automated the database refresh process from production to test environments using custom scripts for efficiency.
Established linked servers between SQL servers and data sources such as DB2 and Oracle to broaden data integrations.
Supported VMware and SharePoint backend databases to ensure operational reliability.
Created databases, logins, roles, and granted appropriate user permissions. Identified and mitigated security threats, including SQL injection attacks using credential and proxy accounts.
Contributed to planning and implementing SQL Server Security Audit compliance for regulatory adherence.
Collaborated with the offshore team on outstanding issues and coordinated migration project activities to meet deadlines.
Developed and executed SSIS packages and SSRS Reports for enhanced reporting capabilities.
Administered Windows and SQL database user and group accounts utilizing Active Directory.
Handled day-to-day support tickets, resolving developmental and production issues promptly.
Provided round-the-clock production on-call support to ensure system availability.
SQL Database Administrator (DBA)/Developer Dec 2012 - Oct 2014 Genworth Financial, Richmond
Install, configure and administer MS SQL server 2012 and 2014. Migrate instances and databases from SQL 2012 to SQL 2014. Configure and administer Availability Groups for high availability/Always On of multiple databases.
Successfully Installed, configured and administer a traditional SQL Server failover Cluster with 2 nodes.
Created and administered various jobs to handle different tasks and to monitor resources on various servers and to email the necessary information when threshold was reached.
Apply SQL Server patches; Service Packs, Hot-fixes, and Cumulative Updates as required and created documentation for tracking. Implement Database optimization such as performance tuning and improvement using Dynamic management views and functions and others. Design, Develop and implement SQL server reporting service that extracts data and present in the user-friendly formats.
Intensively analyzed the existing system in regard to the database administration and produced an inception report which describes the existing situation, pros and cons, and future intervention and plan of action (short, midterm and long-term).
Created linked servers to perform distributed queries and data transfer. Establish a modality to collect the information and documentation of the existing system.
Develop procedures/protocols on database planning and implementation, database security aspects, database auditing, backup and restore modality. Review the current procedure of backup and restoration and introduced the differential back-up into the system and periodic restoration of backups. Applied SQL Server best practices.
Worked with database developer team for database design, data modeling and normalization.
Assisted developers in the process of Extract, Transform, Load (ETL) in data warehouse.
Created SSIS Packages for Data Flow, Object Migration and Database Maintenance.
Run DBCC commands to check the database consistency and shrink the databases.
Monitored and troubleshoot server performance, database activities and clients’ applications.
Manage Very Large databases (VLDBs) of 1TB and more using Table Partitioning, Backup and data Compression and Multiple file-groups. Responsible for Designing and implementing the backup strategy required as per the requirement on production and development environments. Overall follow-up of the system and user support to address any issues and plan for potential problems in advance.
Contact this candidate