Job Description :
POSITION:PL/SQL DEVELOPER
LOCATION: Suitland, MD
DURATION: Long Term
Responsibilities of the PL/SQL Developer:
Applies extensive expertise in PL/SQL
Solves complex problems that require the regular use of ingenuity and creativity
Performs work without need for direct supervision
Makes sound decisions that achieve critical organizational objectives
Ability to design, evaluate, select, implement, and support databases and metadata structures and previous experience redesigning data systems and processes
Ability to analyze information needs and elements, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities
Ability to review requests for data and data usage, research new and/or better data feeds, coordinate new data developments ensuring consistency and integration with existing data warehouse structures
Ability to coordinate testing of designed applications, design dictionaries, database structure and layout, installing, upgrading and managing database applications
Ability to evaluate and make recommendations on data integrity, performing proactive maintenance such as ensuring continued space availability, monitoring activity, and documenting problems, and continuous efforts to improve performance and functionality
Required Experience of the PL/SQL Developer:
10+ years of related database development experience
Strong PL/SQL development experience including but not limited to the creation of packages, procedures, tables views, functions, etc
Oracle database design and performance tuning
Seven years of experience in Database Star Schema and or Snow flake schema in First, Second and Third normal form
Knowledge on how to build/maintain efficient database tables structure for both transactional and warehouse data
Six years of experience in PL/SQL tuning
Knowledge of oracle partitioning practices and data archival structures and processes
Knowledge of Oracle 11g and 12c with use of tools such as SQLDeveloper, TOAD and ERWIN
Experience with batch job process, ASP, VB script, and Windows
Must have the ability to work with the system analysts to translate business requirements to database structure as well has communicate the design to the front end development staff
Strong working knowledge and experience with MS SQL Server.
Strong knowledge in SQL Data Definition Language (DDL) and Data Manipulation Language (DML)
Proficient in designing, creating and debugging stored procedures
Create and execute SQL scripts to be used for test validation
Work directly with databases to verify data using SQL queries
Must be able to obtain a Public Trust designation (US Citizenship or Green Card status required)