Mandatory Skills:

• 5+ years of database development experience, 
• PL/SQL, SQL,
• SQL and database design,
• MS SQL Server 2008/2012, Oracle 11g/12c .

Job Description:

• The Client is seeking a Senior Database Developer with solid experience and knowledge pertaining to designing, developing and implementing of enterprise level database support, with experience using Active Batch scheduler. Candidate must be able to apply system solutions to business problems.
• The Enterprise Database Team is composed of 3 oracle DBAs, 2 SQL server DBAs and a team leader. The team is upgrading from SQL server 2008 to SQL server 2012. Oracle BI Publisher/Answers & Dashboards (OBIEE with Exalytics) is implemented. All reports will be assessed using Oracle technologies. Current reports utilize the enterprise data warehouse (Oracle Exadata) and connections to SQL Server and Oracle databases.
• The enterprise database team works with all facets of the transportation enterprise from financials, programs/projects, human resources, to federal level. The team coordinates with client, server, network, and database/data warehouse personnel to integrate supporting IT architecture.

Responsibilities:

• Designs, develops, tests, and implements databases and views based on business requirements
• Develop database loading procedures, cron/SQL Server Agent jobs, and use ActiveBatch for job scheduling/management
• Work with IT Project team to develop database solutions to business requirements
• Work directly with Enterprise Data architect to design/develop new structures, make requested changes and perform updates
• Create and manage database objects: structures, tables, procedures, triggers, db links, indexes, synonyms, functions, etc.
• Follow IT guidelines, standards, policies, and procedure including but not limited to change management
• Work with IT developers to ensure data security/governance rules are followed
• As needed, thoroughly document existing processes or built as part of these duties
• Deliver database solutions as per IT Project schedule and quality expectations
• Troubleshoot and resolve technical issues with minimal user disruption
• Manage capacity and performance requirements
• Works closely with application developers to integrate databases and test within applications
• Provide design and development mentorship/cross-training with fellow team members
• Assists in the administration and auditing of database system/system security
• Prepare estimates of time for design and development
• Analyzes top database queries and develops performance improvement recommendations for application developers
• Analyzes database performance tuning and develops methods to improve database performance
• Develops and maintains data dictionary/metadata to support data governance

Required Skills:

• 5+ years of database development experience
• 5+ years of experience in writing PL/SQL, SQL*Plus, database scripting, etc.
• 2+ years of experience in Active Batch or similar job scheduling/management tool
• A solid understanding of SQL and database design
• Experience with stored procedure languages
• 4 year Bachelor’s degree with preferred concentration in IT, data science, or business
• Demonstrated experience in designing, building, implementing, and deploying database tables, procedures, functions, views etc.
• Strong knowledge of MS SQL Server 2008/2012, Oracle 11g/12c
• Experience with deploying/upgrading database systems
• Ability to extrapolate business requirements into database design/objects
• Ability to meet deadlines, be results focused, and deliver high quality work products
• Experience in data analysis and data validation
• Must be able to write technical documentation

Detail oriented

• Highly organized with the ability to multi-task
• High level of customer service
• Excellent communication skills

Desired Skills:

• Oracle or Microsoft database training/certifications
• Knowledge of Oracle Financials (PeopleSoft), and Primavera/P6 Analytics, Human Resources (Time and Labor), and Learning Management a plus
• Experience in Oracle BI (OBIEE)
• Experience with Microsoft SharePoint

The company is an equal opportunity employer and is committed to maintaining a professional working environment that is free from discrimination and unlawful harassment. The Management, contractors, and staff of company shall respect others without regard to race, sex, religion, age, color, creed, national or ethnic origin, physical, mental or sensory disability, marital status, sexual orientation, or status as a Vietnam-era, recently separated veteran, Active war time or campaign badge veteran, Armed forces service medal veteran, or disabled veteran. Please contact us.

Alena Matveeva

Professional Recruiter 

http://aworkabroad.com

facebook.com/alena.matveeva.902

twitter.com/AlenaMatveeva08