Ahmed Babikir

Reston, VA *****

adzmnw@r.postjobfree.com

720-***-****

Professional Experience:

●Oracle Database administrator with over 6+ years of diversified data processing experience in Data Design, Data molding, data profiling, data quality, and DB Development. Extensive experience in Data immigration, Data Loading, Database Modeling, Data Mapping, ETL processes and Performance Tuning.

●4+ years experience using MS SQL Server 2018, extensively worked on data extraction, transformation, and loading data from various sources like Oracle, SQL Server, and flat files. Develop, implement, administrate

Experience using feature Dynamic Procedures, functions, Designing database schema in security access control. Hands-on experience on configuring, integrating, and maintaining include staging and production database.

●Involved in entire life cycle of the project (SDLC). Worked on integration and implementation of projects and products, database creations, modeling, calculation of object sizes, table spaces and database sizes, OLAP.

●Experience includes tuning & optimization, database installation, configuration, creation, database monitoring,

●Oracle utilities (Export and Import), shell scripting to perform database routine monitoring, patching, and backups and recovery.

●Experience working in complex mix environment and various platforms include VM, SQL Server, Oracle, upgrade procedures. Working experience in production, and development environment.

●Experience opening, closing, copying, importing and exporting, used utilities like SQL *Loader, Export/Import, PL/SQL tables, Dynamic SQL, oracle supplied packages for loading, immigrate data and flat files and other sources.

●Extensively worked on Functions, Procedures and Triggers in PL/SQL.

●Used External tables to load data from external files.

●Experience in debugging for Extraction, Transformation and Loading processes.

●Data modeling and design with documentation, ER Diagrams, MS Visio.

●Excellent analytical skills, logical reasoning, interpersonal skills, attitude to lead and leadership skills to work in team environment. Excellent communications skills, fast & enthusiastic learner, excellent work ethics and a good team player.

●Hands-on experience on all aspects of the OGG design, implement and support in development, in production environments. Identify and resolve OGG problems occurring in all database environments including performance related issues.

●Equipped with an excellent work ethic, possess strong sense of responsibility and integrity.

●Great attention to detail, proven ability to work efficiently and organized in fast paced work environment

●Created shell scripts and updated the scripts as per the requirement.

●Implement, maintain and test Disaster Recovery methodology for all production databases.

●Work with application owners and technical architect’s requirements and support needs.

●Implement database security including password management, encryption, and DB auditing.

●Maintain and publish documentation for Mediacom-specific needs.

●Coded program in Universal Basic to fulfill specifications and users requirements.

●Attend meetings with application teams and external product and services vendors.

Security clearance:

Recent Public Trust investigation through the SEC.

Career Objective:

•To secure a challenging position as a DBA in an established organization and utilize my technical skills and IT knowledge for managing organization's projects

RELEVANT SKILLS

Interpersonal

•Work well independently and with team to meet objectives and deadlines.

Computer Skills:

•Operating Systems: SUN Solaris v5.8/5.6, LINUX RHL, Windows Vista/XP/2000/NT 4.0/98/95.

•RDBMS: Oracle 11g Oracle 19c, Oracle 12c, MS SQL Server 2016.

•Languages: SQL, PL/SQL, RMAN, Linux, and UNIX Shell Scripting, .NET.

•Oracle Utilities: SQL *PLUS, SQL *Loader, PL/SQL, import, export, datapump, Oracle SQL Developer, GoldenGate.

•Other Tools: TOAD, SQL Navigator, MS VISIO, PuTTY, SharePoint.

•ETL Tools: SQL*Loader, SSIS

WORK History

EVMS Database Admin September 2022-May 2023

Database Admin, CACI International, Chantilly, VA Nov 2018- March 2022

DBA, Revature, Reston, VA Jul 2018-Oct 2018

Jr.DBA, Cañar Telecom, Sudan Oct 2017- Mar 2018

Help Desk Technician, Jr. SQL Server DBA, Denver CO Aug 2014- Jun 2017

EDUCATION

Master of Computer Science/ Database System (Dec 2017), Colorado Technical University, Aurora, CO

Techsherpass, MS SQL Developer Career Training Program, completed successfully querying data with TSQL.

Techsherpass, MS SQL Developer Career Training Program, completed successfully developing SQL database.

Bachelor’s Degree Information Technology, Denver Metropolitan State University, Denver, CO.

Bachelor’s Degree Business Administration Science, Omdurman Ahlia University, Khartoum, Sudan.

WORK EXPERINCE:

EVMS September 2022 – May 2023 735 Fairfax Ave Norfolk VA

Database Admin:

Design automated systems to mine information and make reports

Provide inputs for developing newer versions of databases customized to peculiar needs. Include objects in database like tables, views, functions, triggers, etc.

Wrote store procedures for automatic generation of reportS.

Automation of data load using store procedures

Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.

Perform SQL tuning and assist developers with coding PL/SQL.

Created shell scripts and updated the scripts as per the requirement.

CACI International Inc November 2018 – March 2022 14370 Newbrook Drive.

Subject Mater oracle Database Admin:

•Install, configure, upgrade, migrate and patch Oracle 12c, Oracle 19c, and SQL Server databases, on UNIX and Red Hat Linux. Work at OS level on Linux, writing scripts and configuring storage.

•Created shell scripts and updated the scripts as per the requirement.

•Load high volume data and Performance tuning.

• Performance Tuning and optimization using, EXPLAIN PLAN, tkprof, various types of hints, partitioning methodologies, indexes, and oracle supplied packages DBMS_SQLTUNE, DBMS_PROFILER, DBMS_STATS, and DBMS_XPLAN.

•Monitor system performance using ASH, AWR reports, writing batch programs using, scheduler features to create automatic monitoring and management processes.

•Developed scripts for inbound and outbound of the data on servers.

•Supported all the UNIX requests for various applications.

•Extensive space allocation to various applications upon requirement, detaching and clearing the devices if not in use.

•Work in an Oracle 12c, Oracle 19c environment including RAC, ASM, RMAN, PL/SQL, OEM Grid control (10gR2 and 12c), Data Guard, and Partitioning, database performance tuning, and configuring options such as Oracle Resource Manager.

•Database creation, and management for single and multi node RAC. Implement ASM data storage in RAC environment.

•High Availability database environments include RAC, GoldenGate. Active/Passive Active/Active.

•Implement design and maintain Oracle databases in RAC,

•Setting up Oracle GoldenGate one-way, tow-way/bi-directions, active-to-active, and active-to-passive data replication with conflict detection and resolutions.

•Implement OGG features such as integrated capture, native DDL capture, coordinate mode, multi thread replicate, and parallel mode replicate. Developed home-cooked OGG lag monitoring scripts and configure OGG monitoring plug-in in OEM 12c.

•Implement and manage all aspects of the OGG design such as Manager, Extract, Data Pump, Collector, Replicate, and Trails Files. Identify and resolve problems occurring in all database environments including performance related issues. SQL tuning.

•Install, configure, upgrade, migrate and patch SQL Server, and Oracle database on Linux environment.

•Implement, maintain and test Disaster Recovery methodology for all production databases.

•Work with application owners and technical architect’s requirements and support needs.

•Implement database security including password management, encryption, and DB auditing.

•Maintain and publish documentation for Mediacom-specific needs.

•Maintain Data Design, Data molding, data profiling, data quality, and DB Development

•Attend meetings with application teams and external product and services vendors.

•Involved with business users for gathering and analyzing requirements, logical and physical design of the applications.

•Conducted one-on-one sessions with clients, business users to gather data warehouse requirements.

•Analyzed database requirements in detail with project stakeholders, by conducting joint Development session.

•Develop conceptual, Logical, and physical models to design OLTP system for case-tracker system, expenses system.

•Create dimensional, sub dimensional tables and fact table to create a Physical data model with DDL that best suit the requirements.

• Responsible for Server 2010 installs, configure and support Active Directory, DNS, DHCP, WINS. Responsible for Windows servers administrator Enterprise level, maintain Active Directory.

•Used ERwin for ER diagrams and for schemas designs.

•Setting up High Availability Oracle Golden Gate (OGG) systems on Oracle 19c environments (Back-end: Oracle 19c).

•Troubleshooting typical OGG technical problems such as unique key violation / long transaction abend by using GGSCI / Log dump / discard file analysis etc.

•Performance Tuning OGG in extremely high data volume environments.

•As part of Magellan’s ASD Data warehouse team, written complex PL/SQL packages involving complex business rules.

•Work with business, business analysis, and system administrator on configuration the tools and report requirement.

•Attend client meeting and discussions collect requirement.

Revatuer Inc Jun 2nd, 2018 – October 1st, 2018 11730 American plaza Dr.

Jr. Database Administrator

Install, configure and upgrade the database Oracle 12c, Oracle 19, and servers to suit the database needs.

Design automated systems to mine information and make reports

Provide inputs for developing newer versions of databases customized to peculiar needs. Include objects in database like tables, views, functions, triggers, etc.

Control the access for database by controlling privileges and permissions.

Wrote sequences for automatic generation of unique keys to support primary and foreign keys constraints in data conversions.

Automation of data load using Korn shell scripting and SQL*Loader.

Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.

Perform SQL tuning and assist developers with coding PL/SQL.

Created shell scripts and updated the scripts as per the requirement.

Developed scripts for inbound and outbound of the data on servers.

Supported all the UNIX requests for various applications.

Attend meetings with vendors, application team, external product

Created the design documents based on user requirements.

Per user requirements loaded the data into dimension tables for reporting requirements.

Develop operational plan for ETL, Data loading and data cleaning process and wrote scripts for automation using shell scripting.

Experience with Star Schema Modeling and Snowflake Dimensional modeling

Created partitioned tables, partitioned indexes for manageability and scalability of the application.

Written complex SQL queries and PL/SQL procedures/packages to extract and process data from various source tables of data warehouse.

Canar Telecom October 2017 - March 2018 Sudan, Khartoum

Jr. Database administrator

Responsible to develop and maintain the databases, Oracle 12c, SQL Server2016.

Build up the database architecture and models.

Design the schemes, permissions and tables for database as appropriate for its use.

Install, configure and upgrade the server to suit the database needs.

Design automated systems to mine information and make reports

Created shell scripts and updated the scripts as per the requirement.

Developed scripts for inbound and outbound of the data on servers.

Provide inputs for developing newer versions of databases customized to peculiar needs, Include objects in database like tables, views, functions, triggers, etc.

Control the access for database by assigning privileges and permissions.

Wrote sequences for automatic generation of unique keys to support primary and foreign keys constraints in data conversions.

Automation of data load using Korn shell scripting and SQL*Loader.

Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.

Perform SQL tuning and assist developers with coding PL/SQL.

Tuning long running SQL queries using CBO hints, explain plan, TKPROF and Auto trace. Used DBMS_STATS package and ANALYZE to generate statistics for CBO.

Involved in writing complex scripts for Data Transformation, ETL process (Extract, Transform & Load)

Used SQL *PLUS to generate and format ad-hoc reports

Create various UNIX scripts for enhancing loading process and techniques for restartability of jobs

Used UNIX Shell scripts (KORN Shell) for Extracting and Parsing data from the files.

BI Consultant group August 2014 - June 2017 Denver CO

Help Desk Technician, Jr. SQL Server DBA

Automated the installation of software to 1200 end-user PCs via DOS batch files, Symantec Basic scripting, and Novell Application Launcher snapshot technology.

Provided second level support to internal Help Desk to resolve user concerns with specific applications, including Windows 95, Microsoft Office, GroupWise, and numerous industry specific applications.

Supported all the UNIX requests for various applications.

Identified and implemented technologies and methods of using existing technology to help users work more efficiently, including:

Creating/revising and spreadsheets in Excel, and VBA programming.

Prepared documentation and training materials, coordinated technology related training.

Participated in conversion of 1200 PCs.

Assisted in deploying Help Desk, including software selection and development of procedures Worked on the Help Desk to provide support for software, printing, and network access issues.

Jr. SQL Server DBA

Work with programming staff on database design changes to meet business requirements.

Implemented SQL Server based solution to consolidate dozens of scientific data collection and reporting applications.

Collaborated with faculty member, scientist and staff to design data intensive applications to capture, organize, analyze and report on data collected from scientific experiments and external sources.

Performed day to day DBA activities such as monitoring SQL Server health, job status, addressing user requirements.

Took responsibility of maintaining the SQL Server instances to ensure software is properly installed, security patches were applied and upgrades were done.

Safeguarding data by instilling backup, managing user access and securing databases.

Approved and ran scripts for Quality Assurance and Production releases.

Diagnosed job errors and implemented solutions or worked with developers and/or Server Administration as necessary to solve break/fix and other issues.

Contact this candidate