adh6kd@r.postjobfree.com

***-***-***

OBJECTIVES

Over 10 years of experience in various Information Technology Systems, and Database administration roles seeking a position as a manager, an instructor, cyber security analyst or a field service representative. Well versed in various aspects of database technologies (administration, performance tuning, and security orientation), advanced troubleshooting and deductive reasoning skills with ability to independently multi-task or work collaboratively with a team in a fast-paced technical environment. Self-motivated with the ability to work in a fast-moving environment. PROFILE SUMMARY

• Monitor computer networks for security issues.

• Investigate security breaches and other cyber security incidents.

• Install security measures and operate software to protect systems and information infrastructure, including firewalls and data encryption programs.

• Create email filters to block unwanted SPAM and phishing messages from reaching employees.

• Document security breaches and assess the damage they cause.

• Work with security team to perform tests and uncover network vulnerabilities.

• Fix detected vulnerabilities to maintain a high-security standard.

• Stay current on IT security trends and news.

• Develop company-wide best practices for IT security.

• Perform penetration testing and vulnerability scanning of production environments.

• Help colleagues install security software and understand information security management.

• Research security enhancements and make recommendations to management.

• Stay up-to-date on information technology trends and security standards.

• Provides technical and operational database administration for MS SQL server in Dev, Test and Production environment.

• Installs computer security software, conducting regular security audits, preparing security status reports, educating users on computer security, creating security documentation for users, assisting in disaster recovery and gathering evidence regarding cybercrimes.

• Ability to triage quickly to identify the root cause and escalate the issues when necessary, a strong background in Computers and a proven ability to learn new things quickly

• Thoroughly documents all fix actions required to remediate system failure

• Monitors computer networks for security threats or unauthorized users, identify compromised machines and report on security measures, analyze security risks and develop response 2

Dereje Aynalem / (571) -577-1278 / adh6kd@r.postjobfree.com procedures, developing and testing software deployment tools, firewalls and intrusion detection systems.

• Experience configuring and implementing various technical security solutions, extensive experience providing analysis and trending of security log data from a large number of heterogeneous security devices.

• Performs physical security assessments of servers, computer systems, and network.

• Experience in performing automated penetration testing and Vulnerability Assessment.

• Able to troubleshoot SQL related technical issues.

• Experience in MS SQL Server Performance Tuning, Query Optimization, Client/Server Connectivity, Data Transformation Services and running Database Consistency Checks Using DBCC.

• Windows Server Failover Clustering and SQL Server Always on Availability Groups to support high availability and disaster recovery.

• Experience in Data Migration between SQL Server 2000 and 2005; Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and SSIS.

• Develop and deploy SSIS, SSAS, and SSRS.

• Outstanding communication (written and spoken) and reasoning skills.

• Dedicated to continuous learning and improvement. EDUCATION

University of Maryland University College (UMUC)

B.Sc. Computer Networking and Cyber security

CERTIFICATIONS

Microsoft Certified Solutions Associate: SQL Server 2012 Microsoft Certified Solutions Associate: SQL Server 2008 Microsoft Certified Technology Specialist

CompTIA Security +

PROFESSIONAL MEMERSHIP

Microsoft Certified Professional

TRAINING

Fundamentals of Computer Troubleshooting

Fundamentals of Networking

Network Security

3

Dereje Aynalem / (571) -577-1278 / adh6kd@r.postjobfree.com Windows Server: Install and Storage

Linux System Administration

Internet Information Services 7.5 Administrations

EXPERIENCE

A results-oriented data professional with a distinguished background in SQL server implementing high availability solutions such as database mirroring, always on, replication, log shipping, SQL Server clustering, database backup and disaster recovery procedures. Technical subject matter expert with hands on experience using industry leading replication and monitoring tools such as Spotlight, Fog Light, Idera Diagnostic Manager and Golden gate as well as knowledge in design, development, and support of Share Point versions 2010 and higher.

American College of Technology -ACT, March 2020- August 2020 Cyber Security Analyst (Remote)

My Responsibilities were

• Monitoring and Detection, Vulnerability Assessments.

• Intrusion Prevention and Detection, Access Control and Authorization.

• Policy Enforcement, Application Security, Protocol Analysis, Firewall Management, Incident Response, Data Loss Prevention, Encryption, Two Factor Authentication, Web filtering, and Advanced Threat Protection

• Incident Response ( identify and determine root causes of incidents and provide any required documentation and possible evidence to authorized personnel who carry legal or investigative authorities)

• Implement security scans, continuous analysis, and patch systems and manage networks rights and client access to maintain secure procedures and tools.

• Create IDS alerts and perform basic IDS (Snort, Suricata, Bro/Zeek, etc.) rule creation and tuning based on indicators in network traffic, identifying incidents and events in company’s data.

• Conduct packet level analysis using tcpdump or Wireshark on the session and surrounding traffic of an IDS alert.

• Writing an incident report.

SP PLUS Corporation, July 2017 – Feb 2020

Project Manager

My Responsibilities were

Revenue Reporting and Budget Management- Manage the operation’s budget and make recommendations to reach or exceed budget if unforeseen circumstances arise. Identify all procurement and vendor service needs of the location. Perform general accounting duties such as 4

Dereje Aynalem / (571) -577-1278 / adh6kd@r.postjobfree.com accounts payable, payroll and petty cash. Prepare daily bank deposits and ensure all cash receipts are deposited daily into the facility’s bank account. Monitor office audits and cashier reports to maintain vigilance over possible employee theft and/or inefficiencies.

Troubleshoot any SQL related technical issues.

Workforce Management- Identify proper staffing levels, hire, develop and train a team of employees to deliver superior customer service and perform daily job functions. Employees include attendants, cashiers, bookkeepers, and maintenance personnel. Supervise employee performance to ensure all duties are completed to the highest standard, and provide additional training or disciplinary measures as necessary.

Client Retention & Satisfaction- Ensure pro-active communication with client regarding opportunities to improve operations. Resolve client requests, concerns and issues diplomatically. Monitor facility maintenance for cleanliness standards and make recommendations to improve the aesthetics of the facility.

Developing budgets and P&L review.

Exceed Database Solutions, Ltd.

June 2016 – July 2017

Database Administrator

My Responsibilities were

Answering calls and responding e-mails for end users, create ticket using the CRM tool at hand to keep track of lists of user requests and other IT support related issues.

Trouble shoot and problem solve for customer or member accounts and issues.

Installing new SQL Server 2014 & Upgrading SQL Server 2012 to 2014

Installing, configuring SQL 2016, SQL 2017.

Stretch Database, on-premises SQL Server into the Microsoft Azure SQL Database.

Migrating Sql 2012 to Sql 2014.

Installation, configuration, patching, supporting and upgrading MySQL servers

User Data and Log File Management.

Scheduled tasks on a daily/weekly basis using scheduling tools like Autosys.

Database Configuration Settings; Configuring Critical Maintenance Jobs.

Setting Up Alerts for Critical Errors.

Developed SSIS Packages to extract, transform and load SQL server files, oracle files and flat files to SQL server 2012 and SQL server 2014

Developed security policy and enforced it by adding users, logins, and groups to the databases and granting/revoking permissions on Database objects.

Performing and reviewing system vulnerability scans using software tools.

Hardening the database to the fullest extent by running the most up-to-date version of the database software with all database security patches installed to remove known vulnerabilities.

Design, implement and maintain database backup and recovery strategies and security policies. 5

Dereje Aynalem / (571) -577-1278 / adh6kd@r.postjobfree.com

Implementing third party multi server enterprise level backup/restore tool for encrypted/compressed backup, like sql safe, lite speed, Red Gate, Netback up, Ultra Bac, and Symantec Backup.

Testing; Monitoring; and Documentation.

Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.

Implementing SQL Server high availability& Disaster Recovery Plan -log shipping, mirroring, replication & failover cluster.

Developed Different Maintenance Plans for database monitoring

Monitor Server Activity, Error Log, space usage, and solving problem as needed.

Creating Clustered Indexes and Non-Clustered Indexes to increase the performance of database queries.

Managing indexes, index maintenance (rebuild & reorganize), integrity checks, configuration, patching.

Troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.

Provide 24/7 including after hour weekend technical support and monitoring. Sholla Corporation

July 2013 – June 2016

Jr SQL Database Administrator

My Responsibilities were

Installed, Configured, and Maintained SQL Server 2014, 2012, and 2008 R2 in development, test, and production environment

Configured and Maintained Fail-Over Clustering using SQL Server 2012

Installed and Configured SQL Server Reporting Services (SSRS)

Developed and deployed different types of Reports using different data sources like SQL Server, Oracle, Excel, CSV files.

Configure Windows Server Failover Clustering and SQL Server AlwaysOn Availability Groups.

Developed SSIS Packages from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources

Customer Support, Accounting, Technical Support, Programming, and/or Audit.

Hands on experience in implementing GenTax, integrated multiple tax processing software

Administering the MS SQL Server security by creating user logins with appropriate roles.

Creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintained Referential Integrity.

Troubleshooting, Tuning and Performance optimization. 6

Dereje Aynalem / (571) -577-1278 / adh6kd@r.postjobfree.com

Implementing a DBA maintenance plan for MS SQL Server (DBCC, updating index statistics, monitoring database and disk space).

Migrating Sql 2008/r2 to Sql 2012

Managed the use of disk space, memory and connections. Running DBCC consistency checks and analyzing stack traces, if generated, fixing data corruption on application databases.

Resolving various performance issues and running DBCC commands, SQL Tracer, SQL Profiler.

Administering the MS SQL Server security by Creating User Logins with appropriate roles, dropping and locking the logins.

Implementing/deploy web application firewall to protect our mission critical databases from SQL injection attack.

Monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Rebuilding and creating cluster and non-cluster indexes.

Creating and configuring backup and recovery strategies.

Monitor and optimize Database performance by using performance counters, database engine tuning advisor and profiler.

Troubleshooting database problems by using database consistency checker (DBCC) and profiler.

Control and monitor users access to database and maintain database security.

Configure and manage SQL Server services and features by using SQL server surface area configuration and SQL server configuration manager. SKILLS

• Zendesk Customer Relationship Management (CRM) tool.

• Database Expertise: SQL Server2016, 2014, 2012, 2008 R2, 2005, 2000, MS Access, DB2( AS400)

• AWS cloud infrastructure with the core AWS services.

• Network and host-based security applications and tools such as SPLUNK, Symantec, SCCM, Satellite, BigFix, Firepower, Nessus, or Qualys.

• Database Migration: SQL Server to SQL Server, Oracle to SQL Server, MySQL to SQL Server, and MS Access/Excel to SQL Server

• Share Point 2010 and 2016, IBM Lotus Note 8.5 and higher.

• Operating System: Windows Server 2012, 2008 R2, 2003 R2, 2000, UNIX/Linux, VMware, Cloud

• Network scanning tools: Metaspoilt, Burpe Suite, Cobalt Strike, Tenable Nessus.

• Advanced knowledge of TCP/IP protocols

• Advanced knowledge of NIST 800 series and ISO2700 best practices.

• Languages: SQL, T-SQL, HTML, DHTML, XML.

• ETL/Data Warehouse Tools: SSIS/DTS, BCP

• Reporting: SSRS (SQL Server Reporting Services) – Enterprise Reporting

• Data Modeling Tools: ERWin, Toad Data Modeler, Visio, SSDD (SQL Server Database Diagram)

7

Dereje Aynalem / (571) -577-1278 / adh6kd@r.postjobfree.com

• Third Party Tools: Solar Winds, OpNet, RedGate, Idera, SpotLite, ERWin, Visio, Toad Data Modeler

• Networking: Active Directory, DNS, TCP/IP

• Hardware/Storage: SAN, RAID, iSCSI

REFERENCES

Available Upon Request

Contact this candidate