Oracle Database Developer
Resume:
Ahmed Babikir
Reston, VA *****
*****.********@*****.***
Professional Experience:
●Oracle Database administrator with over 7+ 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, ETL processes and Performance Tuning.
●Created logical and physical Database Design, data structures, Data Modeling, Schema Design
●Applied Database Tuning and Optimization, Normalization in the new database design
●Created Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, anonymous blocks, directories, sequences, and synonyms.
●Granted resources, privileges and roles to users
●Tuned SQL queries using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization
●Technologies used: Oracle10g, Oracle 11g, Oracle 12c, Oracle 19c PL/SQL, SQL*Loader, OEM, UNIX Shell scripts.
●Experience includes SQL, T-SQL tuning & optimization, SQL*Loader, database installation, configuration, creation, database monitoring, Oracle utilities (Export and Import), shell scripting to perform database routine monitoring, patching, and backups.
●Experience monitor system performance, writing batch programs using, scheduler features to create automatic monitoring and management processes.
●Experience opening, closing, copying, importing and exporting SQL in Oracle databases.
●Used utilities like SQL *Loader, Export/Import, PL/SQL tables, Dynamic SQL, oracle supplied packages for loading from flat files and other sources.
●Extensively worked on Functions, Procedures and Triggers in PL/SQL.
●Extensive experience in loading high volume data and Performance tuning. Experience in 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, DBMS_XPLAN.
●Used External tables to load data from external files
●Experience in debugging for Extraction, Transformation and Loading processes.
●Responsible for production support and bug fixing.
●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.
●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.
●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 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.
●Attend meetings with application teams and external product and services vendors.
●Run and update RFC methodologies.
●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
4+ years experience using SSRS, SSIS Develop different type of reports including Cost Rollup Report, Expenditure Chart, Cost Summary Report, Funding Report, Project STD report (Spend to Day), Charge Point Repot, Pan Rollup Report, Client Contact Report, Accounting Statement Report, Employee Enrollment account (Direct and Indirect) summary report and other. Create/schedule packages, export/import data.
Involved in demand developing application using VB studio 2015, .NET framework 4.5.
7+ years experience in agile environment, using BMC Remedy.
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, Windows Vista/XP/2000/NT 4.0/98/95.
•RDBMS: Oracle 10g, Oracle 11g, Oracle 12c, Oracle 19c, MS SQL Server 2016, 2017, 2019.
•Languages: SQL, PL/SQL, RMAN, UNIX Shell Scripting.
•Oracle Utilities: SQL *PLUS, SQL *Loader, PL/SQL, import, export, datapump, Oracle SQL Developer.
•Other Tools: TOAD, SQL Navigator, MS VISIO, PuTTY, SharePoint.
•ETL Tools: SQL*Loader, SSIS.
WORK History
Database Admin, Alan Ritchey Inc Oct 2024 – Now.
Database Admin, EVMS Sept 2022- May 2024
Database Admin, CACI International, Chantilly, VA Nov 2018- May 2022
Database Admin, Revature, Reston, VA Jul 2018- Oct 2018
Jr. Database Admin, 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 Admin Career Training Program, completed successfully 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:
Alan Ritchey Inc Oct 2024 – Now 20500 E Colfax Ave Aurora CO 80018
Database Administrator:
Optimize database performance using advanced technologies like query tuning, indexing strategies, and in-memory computing.
Conduct regular performance audits and capacity planning, leveraging AI-driven predictive analytics to anticipate future database needs
Develop and implement database recovery, and high availability solutions, utilizing technologies like database replication.
Implement and manage data security measures, including encryption, and access controls.
Automate routine database administration tasks using scripting languages and orchestration tools to improve efficiency. Lead cross-functional teams migration projects, ensuring minimal downtime and data integrity during transitions.
EVMS September 2022 – May 2024 735 Fairfax Ave Norfolk VA
Database Admin:
Design automated systems to mine information and make reports.
Imegrate Database from Oracle 10g, 11g to MS Serve 2019.
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 – May 2022 14370 Newbrook Drive.
Database Administrator:
•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.
•Install, configure, upgrade, migrate and patch SQL Server 2016, 2017.
•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.
•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 RMAN, PL/SQL, OEM and Partitioning, database performance tuning, and configuring options such as Oracle Resource Manager.
•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.
•Run and update RFC methodologies.
•Involved with business users for gathering and analyzing requirements, logical and physical design of the applications.
•Used ERwin for ER diagrams and for schemas designs.
•As part of Magellan’s ASD Data warehouse team, written complex PL/SQL packages involving complex business rules.
•Create and deploy SSRS financial report. Create tables, import and update date, create the data set using visual studio, add data set and create the sql queries, update report requirements and deploy the report at SharePoint.
•Use .NET framework to add and develop applications. Code using VB. To develop, create and build tables, filtering, print report.
•Building the distributed and scalable web application using Visual studio 2015.
•Create data access layer, business logic layer using .NET 4.0/4.5.
•Work with business, business analysis, and system administrator on configuration the tools and report requirement.
•Attend client meeting and discussion and collect requirements.
Revatuer Inc: Jun 2nd, 2018 – October 1st, 2018 11730 American plaza Dr.
Jr. Database Administrator:
Install, configure and upgrade the database 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 a Administration:
Responsible to develop and maintain the databases.
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, 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 8, Windows 8.1, Windows 10, Microsoft Office, GroupWise, and numerous industry specific 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 from Windows 8.1, to Windows 10.
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