Senior Database Specialist

Description

The Database Specialist will provide geodatabase management services, which will include PL/SQL development to help their researchers optimize code in a PostgreSQL database. The activities are operating in both on-prem and the AWS Enterprise Data Lake (EDL) environments in development, test, and production.

Requirements

• Bachelor’s degree in computer science or equivalent.
• 7+ years of Application development experience
• 4+ years of Oracle and PostgreSQL Database Development experience
• Oracle and PostgreSQL performance optimization
• Oracle and PostgreSQL database technology
• Oracle and PostgreSQL database administration skills
• Oracle PL/SQL application development
• Strong Experience developing queries, procedures, packages and reports using SQL, PL/SQL
• Strong Experience performing SQL and PL/SQL tuning 
• Strong Experience with Linux including shell scripting 
• Strong experience with performance analysis with large data sets 
• Proficiency in diagnosing performance issues across application tiers.
• Strong experience of physical and logical database design
• Strong experience with Oracle and PostgreSQL application performance tuning tools.
• Ability to anticipate and pro-actively manage issues before they become major problems.
• Excellent troubleshooting and debugging skills 
• Excellent oral and written communication skills including the ability to communicate technical issues to non- technical people.
• Should have experience & ability to work with various teams to resolve performance issues.

Desired Skills & Qualifications

• Experience with Oracle RAC is a plus
• Knowledge of Oracle Spatial data model and objects
• Knowledge of Oracle security management using
• Advanced security, data vault Knowledge of AWS DB deployment and maintenance tools

Primary Responsibilities:

• Assist the development team in the design, development, testing, tuning and implementation of database applications
• Support users and application developers in SQL, PL/SQL tuning and troubleshooting.
• Working with Demographic Frame staff and Application Development and Services
• Division (ADSD) to troubleshoot issues on the EDL for the Demographic Frame Project.
• Review code written by Frames Program researchers and make suggestions for optimization.
• Recommend and implement indexing, partitioning and database vacuuming to allow the written code to run more effectively.
• Have a working knowledge with a database procedural language (Oracle PL/SQL, and/or one or more of the Postgres procedural languages (e.g., PL/pgSQL).
• Listen to recommendations made by other Census Bureau IT professionals and give input to the Frames Program on the recommended tools and design.
• Research new cloud technologies that were recommended by others and helping the team understand how this might impact them.
• Utilize Oracle and PostgreSQL troubleshooting, monitoring tools such as OEM to identify application performance bottlenecks and drive them to resolution.
• Ensures that application design is scalable and maintainable.

Additional Information:

• In order to meet the clearance requirements for this opportunity, candidates must be authorized to work in the US
• All candidates will be subject to a complete background check to include, but not limited to Criminal History, Education Verification, Professional Certification Verification, Verification of Previous Employment and Credit History.
• Public Trust background investigations can take approximately four to eight weeks and requires fingerprinting.

Other Information:

• The salary for this position is $80,000 - $124,000 annually
• For information on SFI's benefits please visit http://www.spatialfront.com/pages/career.html
• This is a full-time W2 position. 
• Please no agencies, third parties, or Corp-to-corp.
• Spatial Front Inc. is an Equal-opportunity Employer, all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
• Spatial Front Inc. participates in E-Verify.