Senior Database Developer

Job Title: Senior Database Developer
Clearance Required: Public Trust
Work Location: Remote

 Key Responsibilities:

• Determine requirements for new relational and non-relational databases
• Develop recommendations and solutions for new database initiatives
• Controlling and monitoring user access to the databases
• Monitoring and optimizing the performance of the databases
• Determine, enforce, and document database policies, procedures. and standards
• Troubleshoot Oracle database performance incidents and problems across Dev, Test, and Production environments
• Perform database and software lifecycle activities to ensure highest level of system performance and availability and compliance with business requirements
• Perform Oracle database and application server administration
• Modify database structures, as necessary, from requirements and DDL provided by application developer teams
• Perform backup, data integrity validation, and restoration activities related to databases using systems such as Oracle Recovery Manager (RMAN), Tivoli Storage Manager (TSM), and operating system scripts
• Use high-speed transaction recovery techniques and recover from database backups
• Ensure compliance with the Oracle license agreement
• Identifying areas for improvement in the current systems
• Ownership of Database tasks and deliverables in Project Plans
• Perform requirements gathering, planning and execution of approved migration activities to other database platforms, including "cloud" platforms
• Analyze data stored in the database and make recommendations relating to performance and efficiency as it relates to data storage
• Develop and maintain documentation related to database technology

Required Qualifications:

• Education:
  • Bachelor’s Degree or equivalent in Computer Science or related field; demonstrated relevant experience and skillsets will be considered
• Experience/Skills:
  • 8+ years of experience in database administration and development primarily in Oracle, but also familiarity with other databases (PostgreSQL, MariaDB) 
  • Demonstrated problem-solving skills and ability to logically analyze complex processes and systems
  • Superior analytical and troubleshooting skills
  • Strong understanding of RDBMS concepts, principles, and security
  • Oracle experience should include: RMAN, partitioning, parallel query, performance tuning, Enterprise Manager, APEX and demonstrated fluency in SQL and PL/SQL.
  • Strong working knowledge (6+ recent years) of Linux OS System Administration. This includes in-depth knowledge and experience with troubleshooting and resolving incidents and problems through the shell (command line interface)
  • Extensive experience (4+ recent years) with Linux shell scripting (e.g. BASH, KSH, etc.) 
  • Write and debug complex Structured Query Language (SQL)
  • Excellent verbal and written communication skills
  • Hands-on experience with database standards and end user applications
  • Excellent knowledge of data backup, recovery, security, and integrity
  • Proven experience with database design, documentation, and coding
  • Previous experience with database case tools, IDEs and CLIs
  • Familiarity with programming languages, libraries, and APIs
  • Problem solving skills and ability to think algorithmically
  • Experience with Git, GitLab
  • Strong bias toward action, delivery, and implementation

Preferred Qualifications:

• Federal government experience a definite plus
• Previous experience providing database system administration support for a scientific community
• Working experience with other relational databases, including PostgreSQL and MariaDB
• Familiarity with cloud-based technologies and processes, with a focus on AWS 
• AWS RDS experience and migrating relational databases from on-premises to the cloud is desired
• Familiarity with non-relational data technologies, for example graph databases, key-value databases (Redis, AWS DynamoDB), search/analytics engines (ElasticSearch), vector databases etc.
• Strong knowledge of the full software development lifecycle, with exposure to Agile or iterative approaches to delivery

 Certification(s):

• Oracle Database Administration 2019 Certified Professional certification

Salary and Benefit Information:

The likely salary range for this position is $69,000- $129,000. This is not