PL/SQL developer

Jamal Shasti

PL/SQL developer
Ellicott City, MD
Member Since Apr 26, 2023

US Citizen

Candidates About

Jamal Shasti

SKILLS SUMMARY

PLSql developer and Senior and certified Oracle Database Administrator (OCP) with a demonstrated history of working in the banking industry, commercial and government on large projects. Over twenty years of solid experiences in Oracle RAC, Oracle Exadata, Database design, physical standby, Golden Gate configuration and Cross-Platform migration from other platform to Oracle 12c.

Area of expertise:

Ø Experience in database design, creation and debugging of stored procedures and triggers, indexes, queries, views, timed as implemented using Oracle 10g, 11g, and 12c

Ø Skills in all phases of project / application design, development, testing, quality assurance and implementation. This includes familiarity with modification of existing applications and response to mid-course corrections and changes in project requirements

Ø Skills in data manipulation into and out from Oracle tables, including Datapump import/export

Ø Team player who can collaborate with peers and medical staff to develop, enhance, and update clinical systems, and adapt to change quickly.

Ø Apply Oracle patches, PSU and CPU quarterly on standalone and RAC patching

Ø Golden Gate replication setup, initial load, ongoing replication and troubleshooting

Ø Providing detail documentation, project plan by providing Visio to review client.

Ø communicating complex technical requirements to nontechnical personnel

Ø preparing and presenting briefings to senior management officials on complex/controversial issues

SECURITY Clearance:

U.S. citizen with active public trust

EDUCATION

Master of Computer Science

John Hopkins University, Baltimore, Maryland

Bachelor of Science in computer

Bowie State University, Maryland

LICENSES AND CERTIFICATIONS

Oracle DBA Certification (O.C.P)

Sybase 10.5 DBA Certified

EMPLOYMENT HISTORY

PLSQL developer Jun 2016, to present

Washington D.C.

Security Exchange Commission (SEC)

o Database design from SEC mission critical Sybase platform to Oracle 12c.

o Redeveloping and converting Sybase TSQL to Oracle PLSQL platform for over 1200 stored procedures.

o Redeveloping majority of the application PLSQL code to incorporate oracle right and left join.

o Developed the ‘Utility’ package that included about 200 functions which is called by other procedures.

o Developed Unix Shell script utilizing Oracle SQL*Loader to reload around 100 static tables nightly.

o Utilizing Sql analyzer to improve PLSQL code resolving culprits and slowness issues.

o Designing the permissions and roles needed for different users based on their job functionality.

o Analysis and design of the tablespaces, tables, indexes, triggers, and partition strategy.

o Performance tuning, utilizing In-Memory Database approach, SQL analyzer, AWR, ADDM and ASH report.

o Golden gate installation, configuration for integrated capture, data pump and integrated replicate parameter files to replicate to three target databases.

o Setting up SSL/ Non-SSL and Wallet configuration.

o Configuring Oracle Advanced Security Transparent Data Encryption (TDE) for sensitive tables.

o Visio documentation and other form of status report created and presented the SEC client on weekly basis for their review.

o Analyzing RAC wait-event for performance related issues.

o Applying golden gate patch to resolve data type replication issue.

o Disaster and recovery utilizing Oracle physical standby

Lead Oracle Database Administrator May 2007 to 2016

Wells Fargo Bank

9062 Old Annapolis Rd. Columbia, MD 21045

Database Management, Design and production support

o Developed database designs based on organizational mission and functional requirements. Defined data elements, data relationships, and data tables using database.

o Analysis and design of the database, tablespaces, tables, indexes, triggers, and partition strategy.

o Conducted database builds of the current releases and changes to the database.

o Working with front-end users to understand their problem and resolve performance issues.

o Worked with the users to change the frequent called PLSQL codes to procedures.

o Release lead working with DBA onsite/offshore team by providing 24x7 support for production and development environments.

o Setup Data Guard for highly impacted Production database as a High Availability solution

o Applying quarterly RAC Clusterware Rolling Upgrades and CPU and PSU patches.

o Executed end-to-end Disaster Recovery drills with production DBAs, UNIX, and Windows team coordinating database and application switchovers/failovers involving 20 applications. Documented all processes and issues resolved for a real time Disaster Recovery

o Responsible for Production Disaster Recovery switchovers as part of DR planning, involving switching over of databases in a Data Guard environment with various components like Weblogic, Business Objects, Autosys, and Golden Gate.

o Extracting ADDM/AWR report from the historical data to isolate the performance related issues.

o Responsible for planning and coordinating the migration of several databases from Sun Solaris to Linux.

o Moving RAC 11g database to Half-Exadata system.

o Responsible for Oracle server installations, upgrades, and patches on Productions and Development Servers.

o Responsible for Oracle 12c Enterprise Manager installation and configuration

o Work with Production Support Groups and Application Managers on analyzing business requirements and responsible for code promotion and validations ensuring smooth development and production deployments

o Setup standard procedures and policies for Application Runbooks for end-to-end delivery of databases and applications

o Responsible for capacity planning for terabyte sized database, setting up security, purging and retention policies for all database environments.

o Responsible for analyzing statistics, tuning applications, and code reviews on all production environments.

o Providing timely resolutions and generating Root Cause Analysis with detailed root causes and solutions for critical apps.

o Submitting SR to oracle and working with them to resolve the issues.

o Supporting Golden Gate replication with integrated extract and replicated configuration.

o Performed database character-set conversion.

o Building RAC servers, creating databases and data physical standby databases.

Senior Oracle Database Administrator May 2004 to April 2006

Maricom System Inc.

1100 Security Blvd, Woodlawn, MD 21207

o Managed and maintained 20 Production Oracle 11g RAC database within an LINUX environment.

o Provided support to 5,000 users, developers, and Business System Consultants.

o Provided leadership and management migrating Production databases from Oracle 10g to Oracle 11g.

o Provided documentation for Database support, Development Database builds, WFS Standards for Oracle 11g RAC installation and Disaster Recovery Testing.

o Worked on a project to migrate a Sybase database to an Oracle 11g 3 node RAC system

o Set up and managed Active Data Guard for several Oracle Standby environments

o Applied Oracle 10g and Oracle 11g PSU patches to production and development environments

o Provided performance tuning and script support to the Development team

o Provided Database support to other Wells Fargo Securities Database teams and Application Managers

o Provided on-call support to Developers and System Administrators

o Performed and implemented Disaster Recovery Testing using Oracle Data Guard.

o Set up and maintained the Backup and Recovery strategy using RMAN

Oracle Database Administrator Sep 2001 to April 2004

Maxim Group, Lockheed Martin

Manassas, VA 20198

o Managed and maintained 10 Production Oracle 11g RAC database within an HP-Unix and AIX environment.

o Upgrading the Global Transportation Network (GTN) system from Oracle 8 to 9.

o Developing backup scripts to perform nightly and weekly backup.

o Provided support to 10,000 users, Developers, and Business System Consultants.

o Responsible for working with Application Managers and Database Administrators to provide information on the status of projects, outages, and DBA resources.

o Provided leadership and management in migrating 100 databases to Oracle 10g RAC

o Set up and maintained Oracle Streams for a reporting database

o Worked with System Architects to provide capacity planning, project sizing, and DBA resources for projects

o Worked with Wholesale Database Managers to provide information on the Line of Business pertaining to the database environment and infrastructure.

o Worked with Offshore Oracle Database to team to train them on our systems, ensure proper access, and provide documentation on the Oracle environment.

o Migrated and coded the migration of a Sybase database to Oracle 9.

Oracle and Sybase Database Administrator May 1999 to August 2001

Romac International

Silver Spring, MD 20910

o Redesigned the Data Network Management system (DNMS) Replication and system architecture.

o Performance & tuning by reviewing sp_sysmon on peak time, analyzing CPU utilization, Disk utilization

o Sybase installation and upgrade from 11.3.3 to 11.5

o Developing Korn Shell scripting for oracle standby replication.

o Responsible for capacity planning for terabyte sized database, setting up security, purging and retention policies for all database.

o Setting up user profiles and privileges and creating application objects.

o Supporting production support and working after hours for system upgrade.

Oracle Database Administrator April 1997 to Mar 1999

Romac International

Silver Spring, MD 20910

o Designing backup and recovery strategy for all databases in Autosys environments

o Supporting Year 2K projects, building all test databases

o Supporting production for hours shift.

o Creating application schemas, users and granting privileges.

o Performance tuning and creating indexes as needed.

Oracle Database Administrator Jun 1996 to Mar 1997

CPI Inc.

American Online, Reston, VA

o Responsible for database creation, logical and physical design.

o Creating objects, setting up crontab jobs for export and import purpose

o Creating new databases and creating new users.

o Monitoring the performance and analyzing the indexes, segment fragmentation

o Production support and resolving after hours issues.

Oracle Database Administrator Jan 1994 to Jun 1996

MYTA Inc. Fannie Mae

Washington D.C.

o Capacity planning for database sizing.

o Setting up security and setting user privileges.

o Production support, export import of database from one database to another.

o Developing archive/purge script to run on weekly basis.

Developer Jan 1993 to Jan 1994

Principal Behavioral Health Care. Inc.

Washington D.C.

o Designing and developing the database for SYSLOG.

o Designing and developing the Renewal database.

o Supporting the Membership database project, working on physical implementation.

o After hours Production support and resolving the issues.

Developer Jan 1987 to Jan 1993

Freddie Mac.

Reston VA

o Analyzed, and supported MERLIN LAN based database system

o Designed and coded the ‘Automated Compliance Eligibility System’ (ACES), a LAN based database.

o Designed and coded SMART system written in C, Greenleaf Library sitting on an Informix database.

PROFESSIONAL DEVELOPMENT / SPECIALIZED TRAINING

Ø Oracle Exadata 10/2015

Ø Oracle Golden Gate Training 01/2015