Resume

Sign in

Sql Developer Resource Manager

Location:
Sterling, VA
Posted:
January 10, 2022

Contact this candidate

Resume:

Ahmed Babikir

* ******* **

Sterling, VA *****

adpvt0@r.postjobfree.com

720-***-****

Professional Experience:

●Oracle Database administrator with over 5+ 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.

●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.

●Technologies used: Oracle 12c, Oracle 11g, PL/SQL, and SQL*Plus, SQL*Loader, OEM, ERwin, RMAN, TOAD, SQL Developer 18, 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, backups restore with RMAN.

●Plan, Implement and test disaster recovery using RMAN and custom written shell scripts

●Experience monitor system performance, writing batch programs using, scheduler features to create automatic monitoring and management processes.

●Experience in designing and maintaining Oracle Database in Clustered environment (RAC) on both Windows and UNIX.

●Experience installing, setup, and maintenance RAC, ASM. Troubleshooting RAC issues.

● Upgraded Oracle 11G RAC databases to 12C RAC with Zero down time method using Golden Gate.

●Create High Availability 11g and 12c RAC Linux clusters (ranging from 2 to 6 nodes) utilizing Data Guard in compliance with Oracle's Maximum Availability Architecture (MAA).

●Implemented DataGaurd (Standby) for high availability/disaster recovery purpose and configured the database to Switchover and failover.

●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.

●Experienced in GoldenGate Install, Configuration, Maintenance, Trouble Shooting and Upgrade.

●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

●Install, configure, upgrade, migrate and patch Oracle 11g, Oracle 12c and SQL 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.

●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 11g, Oracle 12c environment including RAC, ASM, RMAN, PL/SQL, OEM Grid control (10gR2 and 12c), Data Guard, 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.

●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.

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 11g, Oracle 12c.

•Languages: SQL, PL/SQL, RMAN, UNIX Shell Scripting, C/C++, Visual Basic.

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

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

•ETL Tools: SQL*Loader.

WORK History

Database Admin, CACI International, Chantilly, VA Nov 2018- Present

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:

CACI International Inc November 2018 - Present 14370 Newbrook Drive.

Database Admin:

•Install, configure, upgrade, migrate and patch Oracle 10gR2/ Oracle 11g Oracle /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.

•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 11g, Oracle 12c 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.

•Install, configure, upgrade, migrate and patch MySQL, 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.

•Upgraded Oracle 11G RAC databases to 12C RAC using Golden Gate.

•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.

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

•Attend client meeting and discussion and collect requirement

• Created and Managed Production database as well as Development/Test environments using tools like OEM, Performance Pack, SQL Navigator, TOAD, PL/SQL and SQL*Loader.

•Plan, Implement and test disaster recovery using RMAN and custom written shell scripts.

•Create and maintain oracle Data Guard configuration for disaster recovery and to manage planned maintenance.

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 administrator

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 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 from Windows 3.1 to Windows 95.

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