Sql Server Information Technology
Resume:
Tehetina Getahun Tessema
PROFESSIONAL EXPERIENCES:
The Maryland-National Capital Park and Planning Commission(M-NCPPCP), Prince George’s County Department of Parks and Recreation,
Information Technology and Communications Division.
Database Maintenance & Backup: Maintained and backed up departmental databases to ensure seamless customer interactions and data availability. Implemented a script on the SQL Reporting Server for automatic nightly backups, stored locally on Cwith retention set to delete backups older than 3 days. Developed secondary backup processes to copy files to a remote server, with an automated script on the secondary server to delete backups older than 7 days, ensuring data security and compliance.
Compliance & Optimization: Managed database compliance by consistently monitoring licensing and life cycles, recommending actions for efficiency improvements and ensuring alignment with organizational standards.
Upgrade & Migration Planning: Led upgrades and developed detailed migration/retirement plans for both new and legacy databases, reducing downtime and improving overall system performance.
Data Integration & Reporting: Integrated and translated data into departmental reporting systems, including Data Warehousing and Middleware, to streamline access and support decision-making.
Reporting Server Enhancement: Successfully upgraded the Reporting Server, enhancing performance and reliability for departmental reporting needs.
Process Development & Documentation: Developed and documented standardized processes for recurring IT tasks, increasing team efficiency and providing consistent workflow guidelines.
Project Management: Utilized strong project management skills to meet unit goals and deadlines effectively, optimizing time and resource allocation.
Data Security: Performed data mapping and securely transferred database backups to remote locations, maintaining data integrity and mitigating risk.
Oracle Client Installation & Configuration: Installed and configured the Oracle client to support database connectivity, enhancing interoperability and expanding system capabilities for reporting and data access.
LexisNexis Reed Tech
05/2022 –03-2024
Backup/Recovery: Work experience and strong knowledge in disaster recovery. Rebuild databases using backups
Backup/Recovery: Work experience and strong knowledge in disaster recovery. Rebuild databases using backups
Installed, Configured and Maintained HA (High Availability) Solutions – AlwaysOn, Failover Database administrators needed to support, run, and change activities in the DBMS lifecycle. Work closely with dba peers, Report progress to senior management.
Work with the team to ensure appropriate security controls (i.e., Security Technical Implementation Guides (STIGs) are built into all databases and database instances. Oversee the database processes using industry best practices.
Providing support, run, and change activities in the DBMS lifecycle. Work closely with dba peers, product and project leaders/managers, and other in-house software developers.
Skills: STIG · TDE · Data Backup Solutions · System Deployment · Transact-SQL (T-SQL)
BarnAllen-ZAI, BA-ZAI JV, LLC - Fairfax, VA 08/2018 -05/2022
SQL Database Administrator
Responsibilities and Accomplishment:
Installed, Configured, and Administered SQL Server 2012, 2014, 2016 and 2017 in development, test, and production environment.
Designs, installs, monitors, and maintains Dev, QA and production Oracle (10g, 11g) database environments
Installed new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
Troubleshooting errors using Clusterware logs and patching 11g and 12c RAC environments involved in upgradation of databases from 11. 2. 0. 4 to 12c in QA and dev environments
Database High Availability: Installed, Configured and Managed Database Mirroring, AlwaysOn and FailOver Cluster SQL/T-SQL, Triggers, And Stored Procedure: Wrote SQL, T-SQL, Stored-Procedures and triggers. Assisted SQL developers to optimize SQL queries, Stored Procedures and Triggers
Monitoring and Performance Tuning: Performed database monitoring and Performance tuning. Monitor Servers activity, and worked with clients to solve different problems. Performed index and statistics management. Managed SQL Server Error Logs, space usage, growth pattern. Used DBCC and ALTER C statements to check and manage database consistency, index fragmentation/rebuilding, statistics. Managed
BLOCK and LOCK
Database Automation: Created Backup jobs for different types of backup like FULL, Differential and
Transaction Log. Created Jobs for database maintenance Index fragmentation, rebuild, database statistics
Data Modeling: Worked on different Data Modeling projects using ERwin for designing Logical &
Physical Database. Used Backward & Forward Engineering to create Logical and Physical database
Index/Constraints, Triggers, Stored Procedure: Created and managed Index (Cluster/Non-Cluster), Constraints
Security Management: Created and Managed users, group roles, schema, and security at object level, data encryption
Export & Import data from/to Oracle, MySQL, and Access Database including flat files like text, excel, and CSV files to SQL Server 2005/2008
Database Migration: Migrated MS Access databases into MS SQL Server. Migrated Oracle 10g, MySQL database into MS SQL Server 2008R2. Imported data from Oracle, Excel, Flat file, CSV file to SQL Server Database,
Backup/Recovery: Work experience and strong knowledge in disaster recovery. Rebuild databases using backups
Reports: Installed, Configured, and administered SQL Server Reporting Services (SSRS). Developed Reports using SSRS. Developed Ad-hoc Reports using Report Builder 3.0, 2.0. Deployed Reports. Managed security for reports
Veterans United Home Loans- United Drive Columbia 07/2020- 9/2020
SQL Database Administrator/Architect
Responsibilities:
•Installed, Configured and Managed Microsoft 2016, 2019, AlwaysON and Fail-Over Cluster, Mirroring SQL/T-SQL, Triggers, And Stored Procedure: Wrote SQL, T-SQL, Stored-Procedures and triggers. Always On (Spilt Brain in SQL)
•Designs, installs, monitors, and maintains Dev, QA and production Oracle (10g, 11g) database environments
•Maintain and support Oracle 11gr1, 11gr2, 12c rac, physical and logical standby database for test, development, and production for various home-developed applications involve in 24x7 on-call support for 12 databases of 2. 0 TB 4 node production 10g and 11g RAC databases using Oracle 12c cloud control for alert monitoring and notification upgrade dbs from 11. 2. 0. 4 to 12.
•Worked as cloud administration on Microsoft Azure, involved in configuring virtual machines storage accounts and resource group.
•Experienced with cloud Computing and virtualization
•Strong Endpoint devise support experience (i.e desktop Computers, laptops, Surface hubs, surface pro)
•Administrated Azure AD users, groups, and pieces and participate in migration between on -premises and Azure AD through AD connect.
• Installed, Configured and Maintained HA (High Availability) Solutions – AlwaysOn, Failover Clustering, Replications, Mirroring, and Log Shipping.
•Designed packages which utilized tasks and transformations such as execute sql task, execute process task, send mail task, ftp task, execute package task, xml task, data flow task, sequence container, for each loop container, lookup, aggregate, expression, ole db command, and derived column. Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.
•Managed and administered Microsoft 2016 SQL server servers.
•Installed, Configured, and Administered SQL Server 2012, 2014, 2016 and 2017 in development, test, and production environment Database High Availability:
•Assisted SQL developers to optimize SQL queries, Stored Procedures and Triggers and monitoring and Performance Tuning: Performed database monitoring and Performance tuning.
•Security Management: Created and Managed users, group roles, schema, and security at object level, data encryption
•Decom the server and Database, Installed, Configured, and Managed Instances and Databases in SQL Server 2016, 2014, 2012, and 2008R2 in development, Training, Staging, Test/UAT, and Production Environment
•Database Automation: Created Backup jobs for different types of backup like FULL, Differential and
•Transaction Log. Created Jobs for database maintenance Index fragmentation, rebuild, database statistics.
•Designed and Developed ETL Process for integrating data from sources like Excel,CSV, Flat Files, Web Services, XML Source and Microsoft SQL Server 2016
Prism-Perspecta, HPE Contract with the DOD (DMDC), Alexandria, VA 11/2016 - August 2018
SQL Database Administrator/SQL DBA
Major Responsibilities:
•Installed, Configured, and Managed Instances and Databases in SQL Server 2016, 2014, 2012, and 2008R2 in development, Training, Staging, Test/UAT, and Production Environment
•Installed, Configured and Maintained HA (High Availability) Solutions – AlwaysOn, Failover Clustering, Replications, Mirroring, and Log Shipping
•Installed, Configured, and Managed Instances of SQL Server Reporting Services (SSRS)
•Developed, Deployed and Managed Reports using different data sources like SQL Server, Oracle, Excel, CSV files
•Upgraded/Migrated SQL Server and Reporting Server Instances
•Applied SP (Service Packs) and Hot fixes
•Migrated Databases and Instances
SQL Server to SQL Server
Oracle Databases to SQL Server
MySQL Databases to SQL Server
MS Access Databases to MS SQL Server
•Monitoring, Troubleshooting Instances, Databases, Queries using different tools
Query Execution plans
Database Tuning Advisor
PerfMon
Server Logs, Agent Logs and Error Logs, Event Logs
DMV (Dynamic Management View)
Profiler
Indexing, Index and Statistics Management
•Developed and Tune-up Queries
Queries including JOIN, Stored Procedures, Functions and other queries
Worked developers to tune-up queries related to performance issues
•Database Design
Designed new database systems for applications and redesigned existing database systems
Designed Relationship, Keys, constraints, indexes, and other constraints for data integrity and performance
Conceptual, Logical and Physical Design
Backward and Forward Engineering
Used native and Third Party tools – ERWin, Visio, Toad Data Modeler
•Database Architecture – Solid experience on architecting Database Server Instances
•Automations – Create jobs, setup schedules, configure mail server, operators, notifications and other related services Database Backup – Designed backup strategies for development, Training, Staging, Test/UAT, and Production Environment, setup automated backup verification process for backups
•Database Recovery, Refresh and Deployment – Performed Database Recovery, Refresh/Deployment across the environment including Point-In-Time Recovery
•Data Masking, Encryption (TDE: Transparent Data Encryption)
•Monitoring database and server health, lock, block, disk, CPU, jobs and other related services
•ETL Processing Installed, Configured, and Managed SSIS (SQL Server Integration Services) Instance
•Developed, Deployed and Managed SSIS Packages using different types of sources such as Database, Flat file, CSV, Excel and OLE DB supporting sources
•Migrated and Upgraded SSIS Packages
•Setup jobs using SSIS Packages
•Managed security
•Used SSIS packages for many other purposes – Moving logins, databases, data, and for other objects, Instance, Databases, and Users Security Management
Work Environment: Windows Server 2012, 2008 R2, 2003 R2, SQL Server 2014, 2012, 2008R2, 2005, AD (Active Directory), Applications, Reporting System and Databases
Intersections, Inc., Chanteley, VA 08/2010 – 10/2016
SQL Database Administrator/SQL DBA Major Responsibilities:
•Migrated and Upgraded from SQL Server 2005, 2008/2008 R2 to SQL Server 2012
•Configured database software, associated database tools and performance monitoring software.
•Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
•Performed acceptance testing to verify that database changes perform without adverse consequences.
•Managed High Availability Solutions in Database Clustering, Mirroring, and Log Shipping
•Customized support for Client’s Applications and provided client will won the responsibility of creating and maintaining database objects and structures such as tables, indexes, views, triggers, Functions, Procedures.
•Developed & maintained scripts, utility jobs or implement needed software for database maintenance.
•Developed, tested & implemented database backup and recovery strategy with client assistance.
•Monitored data activities such as database status, logs, space utilization, extents, Checkpoints, locks and long transactions.
•Suggested Application level tuning changes for code, queries, SQL objects that may not be performing up to the optimum database performance standards.
•Adhered to Change Control Procedures and developed & executed script changes requests in accordance with change control procedures.
•Set up security and access profiles and procedures for database system administrators.
•Handled Logical Data and Index partitioning for large tables in SQL Server 2005, 2008 & 2008 R2.
•Created, administered & maintained SQL Server Databases to Production, Development, Test and Staging Environment for various groups such as Developer, QA, BA, and User.
•Managed security by defining roles and rights.
•Monitored the database server performance and if required go for tuning of the TSQL queries, Stored procedures.
•Installed and Configured SQL Server Reporting Services (SSRS)
•Applied SP (Service Pack) and patches on SQL Server 2000, 2005, Windows Server 2003 Enterprise Edition
•Expertise in database Performance tuning
•ETL data processing using SSIS
Working individually, as a member of a team, and lead small teams to design and model systems at a high level prior to construction
Work Environment: Windows Server 2012, 2008 R2, 2003 R2, SQL Server 2012, 2008R2, 2005, AD (Active Directory), Applications, Reporting System and Databases
EDUCATION:
•Bachelor of Science
•A.S. – Computer Information Systems Technology – Northern Virginia Community College
•Microsoft Certified: Azure
CERTIFICATION:
•Microsoft Certified: Azure
•MCSA (Microsoft Certified Solutions Associate) – SQL Server 2012/2014
•Training on ETL Database Processing using SSIS, Sufia Institute of Science & Technology
•Training on Report Development, Deployment, and Administration using SSRS(SQL Server Reporting Services, Sufia Institute of Science & Technology
•Training on IIS 7.5: Application & Web Server Administration, Sufia Institute of Science & Technology
HIGH LEVEL SUMMARY OF TECHNICAL SKILLS:
Databases:
Microsoft 2016, SQL Server 2014, 2012, 2008 R2, 2005, 2000, MS Access
Migration Skills:
SQL Server to SQL Server, Oracle to SQL Server, MySQL to SQL Server, and MS Access/Excel to SQL Server
Oracle 10g, 11g 12c, Data Architecture., Data Modeling
Operating System:
Windows Server 2012R2, 2008 R2, 2003 R2, 2000, UNIX/Linux, VMware, Azure, AWS
Languages:
SQL, T-SQL, HTML, DHTML, XML, JavaScript, ASP, ASP.net
ETL/Data Warehouse Tools: SSIS/DTS, BCP
Reporting:
SSRS (SQL Server Reporting Services) – Enterprise Reporting Experience in supporting SSIS, SSRS, replication, database mirroring, SQL Reporting Services, DACPAC, BACPAC, ISPAC concept and deployment/automation of database objects, Skilled in supporting SSIS, SSRS, replication, database mirroring, SQL Reporting Services, ETL operations by SSIS using DTS, BIDS, SSDT, Informatica and SSMA tools. Developed, Deployed and Managed SSIS Packages using different types of sources such as Database, Flat file, CSV, Excel and OLE DB supporting sources.
Data Modeling Tools:
ERWin, Toad Data Modeler, Visio, SSDD (SQL Server Database
Third Party Tools:
SolarWinds, OpNet, RedGate, Idera, SpotLite, ERWin, Visio, SentryOne
Toad Data Modeler Azure IaaS and using tools like IDERA/Redgate/OMS MMA or Dynatrace
Networking:
Active Directory, DNS, TCP/IP
Hardware/Storage:
SAN, RAID, iSCSI
Contact this candidate