Design. Disrupt. Repeat.
Be an agent of change on a team committed to achieving client-focused, mission-driven excellence. Steampunk is looking for an experienced Sr. Oracle Database Administrator with an appetite for taking on new challenges.
Who We Are
Steampunk is the explosive collision of human-centered design and traditional government contracting. An employee-owned company with a startup mindset and time-tested approaches tailored for the federal government, we’re passionate about creating solutions that are impactful, practical, scalable, and most importantly, that meet our clients’ ever-changing needs.
At Steampunk, we believe in disrupting the status quo and setting the pace in the ecosystem of government contractors, while repurposing tried-and-true methodologies. We believe in empowering our people to find creative solutions to intractable problems. We believe the best environment in which to grow and thrive is outside our comfort zone.
While good design makes for a good product, we believe human-centered design makes for an excellent one.
We also believe effective teams are powered by diverse perspectives, backgrounds, and experiences. To that end, Steampunk is an equal opportunity employer committed to promoting diversity of race, gender, sexual orientation, religion, ethnicity, national origin, disability status, and protected veteran status, amongst our ranks. Additionally, we participate in the E-Verify program.
Our people are the very core of what we do; their expertise and hunger for new and exciting challenges fuel our relentless pursuit of mission success. As part of our team of “Punks,” you’ll test the status quo, explore new boundaries, and set the bar high for how government clients expect to engage with contractors.
Because we value our employees’ work/life balance (and believe those who work hard deserve to play hard), we offer a very competitive benefits package, including telework/flex scheduling, health/dental with orthodontics/vision insurance upon hire, paid time off with a sell-back benefit and carryover option, 11 Federal Holidays, 100% paid military leave, 100% 401(k) plan match upon hire, professional development/education reimbursement, all flexible spending accounts, and more.
The Oracle Database Administrator has the responsibility of designing, developing, managing, and administering large ODS (Operational Data Stores), and data mart databases in Azure / AWS Cloud environments. This responsibility includes, but is not limited to, identifying, researching and resolving database design, development and performance issues, and maintaining documentation. This effort will be supporting an Enterprise Data Warehouse and Business Intelligence development program. The DBA will work with the government customer and Agile teams in designing and developing the ODS and Data Marts. The DBA will focus on database performance and assists ETL staff in the efficient data ingest of mission critical data.
• Design and Develop database objects with optimization and security in mind
• Creating the databases and database objects such as the tables, table spaces, synonyms, views, and triggers
• Design and Develop stored procedures, defaults, domains, and indexes
• Maintain and manage the Oracle Active Dataguard based standby databases with the failover services
• Perform pro-active maintenance to identify and defragment database objects to maintain optimal performance for heavy read (OBIEE, SAS) and write (ETL) operations
• Enforce mandated audit and security standards and work to remediate vulnerabilities identified by vulnerability / security scans
• Troubleshoot and tune queries, I/O throughput and OS kernel parameters
• Propose and Implement enhancements that will improve performance and reliability of data quality
• Education / Experience:
o Minimum 10 years of relevant hands-on broad range of skills / experience.
o Eight (8+) years of Oracle DBA experience
o Bachelor’s degree in computer science, information systems or equivalent.
• Key Skills Required:
o Working experience in Enterprise Data Warehousing development environment
o Experience with quickly troubleshooting highly active databases experiencing performance issues
o Knowledge and understanding of designing and developing PL/SQL Stored Procedures, triggers and Query Optimization techniques
o Experience in working with high volume ETL data loads
o Performance tuning of SQL queries
o Working knowledge of Oracle 11g/12c infrastructure
o Experience in using RDBMS IDE tools such as: SQL Developer, TOAD, Erwin etc.
Desired Skills and Experience:
• Oracle DBA certification
• Azure or AWS Cloud experience
Steampunk is a Change Agent in the Federal contracting industry, bringing new thinking to clients in the Homeland, Federal Civilian, Health and DoD sectors. Through our Human-Centered delivery methodology, we are fundamentally changing the expectations our Federal clients have for true shared accountability in solving their toughest mission challenges. As an employee owned company, we focus on investing in our employees to enable them to do the greatest work of their careers – and rewarding them for outstanding contributions to our growth. If you want to learn more about our story, visit http://www.steampunk.com.