MIS 2000, Inc.

Description

• Qualifications Profile

• Five plus years of reliable operational experience in Database Administration of MS SQL Server 2016/2012/2008R2/2008 in Production, Test and Development Environment.

• Experience in installation and configuration of Microsoft SQL Server 2016/2014/2012/2008, applying service packs, hot fix and cumulative updates in development, Test, UAT and production environments.
• Experience in Performance monitoring and tuning using task manager, query optimization, event viewer, index tuning advisor, profiler, database tuning advisor (DTA), services and protocols, and configuration manager.

• Experience in using dynamic management views (DMV) and dynamic management functions (DMF), TSQL scripts, Triggers and Store Procedures.

• Experience in implementing Microsoft SQL Server Security and database permissions.
• Experience in extracting and transforming data using SSIS Import/Export, Bulk Insert, BCP, and SSIS Packages.
• Experience in migrating contents from MS SQL server 2005 to MS SQL server 2012 and from MS SQL Server 2008 to MS SQL Server 2016.
• Expert in creating packages, Jobs, Sending Alerts using SQL Mail.
• Proficient in creating different backup strategies, restore of databases, disaster recovery plans using SQL clustering and log shipping.

• Experience in implementing Always on High availability SQL Server solutions, Implementing SQL Server clustering, Database Mirroring, Log shipping and Replication Models.
• Tuning T-SQL queries to improve performance.

• Experience in code reviews and interaction with developers.
• Participating in business continuity plan review and Plan growth and changes (capacity planning).

• On-call troubleshooting for SQL Server service outages.
• Dynamic problem solving ability, team player, detail-oriented, and quick learner. Strong analytical and interpersonal skills, strong work ethic and effective at meeting project objectives and deadlines in fast-paced environments.

Core Technologies:

Educational Background

• Microsoft Certified IT Professional (MCITP) SQL Server 2012/2014
• Sc. in Management information system | Gondar University, Gondar, Ethiopia

Experience Highlights

Xerox Corporation| DBA, Houston ,TX Nov 2015 -present

• Installed and configured MS SQL Server 2016/2014 on standalone and clustered environments.
• Managed MS SQL Server 2016/2014/2012/2008 databases.
• Implemented database refresh using SSIS packages and automated backup/restore jobs.
• Experience in migrating contents from MS SQL server 2008 to MS SQL server 2016.
• Experienced in applying 2012 /2008 periodic service packs and hot fixes (cumulative updates).
• Auditing of databases for user’s transaction, login and database action and fixing orphan users.
• Managed users and groups (roles) from Active directory or SQL, provide appropriate server roles, map them to specific databases and grant specific privileges over selected database securable objects to ensure security and integrity.
• Analyzed and deployed scripts and packages in prod/test environments from different developers based on CR/change request process.
• Involved in capacity planning and allocation of resources for the databases by assisting application teams in creating databases depending upon the criticality of the databases following current and best practices in accordance with SLA of the company.
• Responsible for forecasting data growth of databases and providing reports on quarterly basis.
• Responsible for creating and monitoring database maintenance plans and schedule jobs using SQL Agent/Maintenance plan; Schedule database integrity check, reorganize/rebuild indexes, update statistics, backup/restore and cleanup job history.
• Extensively used SQL native tools for performance monitoring /analysis and troubleshooting. Performance tuning by analyzing execution plans, creating and maintaining indexes (rebuild/reorganize), Statistics and Client/Server Connectivity.
• Analyzed Locks, Blocks, Dead Locks, Resource Utilization, handling Isolation Level and Concurrency issues.
• Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability. Provided consultation for development teams regarding performance review and the correct usage of database objects and list the most resource-intensive queries on the server and suggest ways to improve performance on each.
• Supported implementation of Always ON, Availability groups by creating availability databases using the high availability and DR strategies in clustered environment.
• Experienced with configuring database high availability techniques like Replication, clustering as well as implementing disaster recovery techniques like database mirroring and log shipping.
• Used free tools to diagnose server reliability and performance issues.
• Monitored SQL Server Error Log, Windows Event Logs, Profiler, Query Execution Plan, Index Tuning Advisor, Database Tuning Advisor, System Monitor, troubleshooting performance issues.
• Experienced in implementing, configuring and maintaining different types of Replication Models like Snapshot and Transactional.

Ethos Energy | DBA, Houston ,TX Jul 2013 – Oct 2015

• Installed, Configured, and Managed SQL Server 2014/2012/2008 in production, development and test environment.
• Experienced in applying 2012/2008 /2005 periodic service packs and hot fixes (cumulative updates).
• Experience in migrating contents from MS SQL server 2005 to MS SQL server 2012.
• Managed database security, creating logins, groups, users, and server level and database level roles following company policies and procedures.
• Created Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, security breach, etc.
• Strong knowledge and working experience in Database Backup and Disaster Recovery. Experienced with Point-in-Time Recovery that meets company’s RTO and RPO. Plan backup strategies based on the recovery models, size of data and IO activity.
• Design, implement and manage database maintenance and disaster recovery plans including full/differential/transactional backups and recovery procedures.
• Implemented pre/post strategies for upgrading and migration of user databases by scripting all SQL server replications, login/users, linked servers, scheduled job, database mail profiles and server level configurations.
• Managed efficient backup system to minimize backup/restore time by applying Database Backup Compression, enabling Instant File Initialization and applying frequent full, differential and transaction log backups.
• Experienced in Extract, Transform and Load (ETL) data from heterogeneous data Sources; MS Access using MS SQL Integration Service (SSIS), DTS, BCP and Bulk insert. Exported data from SQL Server to multiple destination/format such as Flat file, CSV file, Access, OLE DB data sources.
• Imported data from multiple sources such as Flat file, CSV file, Access, OLEDB data sources to SQL Server. Data migration to and from various sources using SSIS.
• Configured Log Shipping as Standby database from Production database for Reporting purposes.
• Installed, Configured and Maintained Database Mirroring.

Ethiopian Airlines| Help Desk and Jr DBA, Ethiopia  Jan 2011-Apr 2013

• Participate in installation and configuration of MSSQL 2008.
• Document the company’s database environment.
• Assist in migration from MS SQL server 2005 to MS SQL server 2008R2.
• Deploy scripts from Development server to production/test servers.
• Restore backups on Development and test servers for refreshment.
• Effectively, professionally, and respectfully represents other Information Technology staff members, teams, and their services to the client community.
• Provided support for all Information Technology products and services. Support may include answering

questions, troubleshooting problems, assist customers regarding software or hardware functionality, and        communicating policy.

• Determine the most effective manner to resolve customer’s technical issue. Engages in research and in

depth troubleshooting to resolve technical issues.

• Verified suggested solutions effectively to resolve the users’ problems through verbal or email follow up.
• Worked on Help Desk related projects as assigned by supervisor.

.