fbpx

Senior Database Engineer (Remote) #4753

Careers

  • US-Remote Employee Location
  • Information Technology
Apply Now

Company Overview

GovCIO is a team of transformers–people who are passionate about transforming government I.T. We believe in making a difference by developing digital strategies and delivering the technology-related innovation that improves governmental operations each day.

But we can’t do it alone. We welcome and nurture an inclusive and diversified work culture. Because different backgrounds, experiences, abilities, and perspectives make us better decision-makers, problem solvers, and creators. We’re changing the face of I.T. – from our diverse staff to the end-products we develop. And we’re excited to expand our team. Are you ready to be a transformer?

 

GovCIO is expanding its development organization in support of a continuously expanding portfolio of solutions. In addition to traditional full stack, n-tiered development patterns, we heavily leverage current and emerging services offered by both AWS and Azure. Our roadmap is continually evolving as we work to identify and deliver transformative capabilities for both our internal and external customers.

 

To support our mission, GovCIO is looking for a highly motivated Senior Database Engineer with the ability to learn quickly and act independently. This is a senior backend developer role, NOT a database administrator or data analyst role. Technical depth in Python, AWS Aurora PostgreSQL, and Amazon Cloud is critical. Knowledge of Microsoft SQL Server is a plus. Must have strong coding skills (not just SQL but Python).

Since our environment leans heavy towards GovCloud environments, experience working with related AWS/Azure IaaS, PaaS, and SaaS technologies is required, while exposure to AWS Database, Architect, Developer, and SysOps certification subject matter is helpful (we will actively support certification attainment). An ideal candidate has both Agile team experience and strong technical experience demonstrating the desired qualifications for this position. Especially the ability to keep releases on track by working well with others to resolve development-related impediments. You must have critical thinking skills, strong problem-solving abilities, and a strong track record of meeting project milestones and deadlines.

Join us for the opportunity to define and drive successes within a team of empowered technologists!

Responsibilities

  • Create, extend, and tune database schemas, stored procedures, and views in highly distributed, cloud-hosted AWS Aurora PostgreSQL environments.
  • Architect, design, and implement data-oriented applications using AWS technologies such as Aurora, DynamoDB, DAX, ElastiCache, Kinesis, Event Bridge, Lake Formation, Glue, Lambda, S3, S3 Glacier, SQS, SNS, RDS, Redshift, IAM, KMS, DMS, SCT, VPC, OpenSearch, CloudWatch, and CloudFormation.
  • Use tools such as AWS Database Migration Service and Schema Conversion Tool to migrate or synchronize data.
  • Build reports using real-time data and PowerBI.
  • Create and maintain data models and data dictionaries.
  • Assist Python and C# developers with database integration efforts.
  • Implement AWS event-driven and batch jobs in Python.
  • Develop performance tests and analyze AWS CloudWatch logs.
  • Participate in GitHub Pull Request (PR) code reviews and merges.
  • Collaborate with multiple teams in troubleshooting complex technical or non-technical issues.
  • Develop complex systems capable of processing large volumes of documents (digital and scanned).
  • As needed: migrate from MS SQL Server, Oracle or other RDMBS and legacy datastores to AWS Aurora PostgreSQL.

Qualifications

  • Bachelor’s Degree in Computer Science, Information Systems, Engineering, Mathematics, Science, Technology, and related fields. On a case-by-case basis, work experience may be considered in lieu of a STEM degree for highly qualified candidates.
  • Must reside and work within the U.S.
  • Eight (8) years of demonstrated experience leveraging relational database management systems to design, implement, and support data systems in support of enterprise application development.
  • Five (5) or more years’ professional software development experience.
  • Three (3) or more years’ experience in PostgreSQL.
  • Three (3) or more years’ experience in Python (equivalent experience in Java, JavaScript, or C# may be substituted on a case-by-case basis for exceptionally strong candidates)

Qualifications – Required Skills and Experience

  • Experience optimizing and performance tuning Postgres including drill-down analysis.
  • Experience building a large infrastructure supporting high volume of transactions in a mission-critical environment.
  • Experience designing, normalizing, and denormalizing relational databases.
  • Experience administering multi-terabyte databases.
  • Experience in analyzing query execution plans, and profiling.
  • Experience supporting PowerBI and/or SQL Server Reporting Services (SSRS), Tableau, Crystal Reports or similar enterprise class reporting and analytics systems
  • Experience in ETL/ELT approaches.
  • Experience with Aurora, AWS RDS, AWS DMS, S3, and CloudWatch.
  • Experience with SQL/database source control in Git.

Qualifications – Required Skills for all Engineers

  • Proficiency with Git, GitHub, and JIRA.
  • Strong system design, application programming, and “clean code” skills a must.
    • Strong coding skills demonstrated by frequent, smooth, professional GitHub Pull Requests (PR) reviews.
    • Strong design skills (includes ability to create diagrams and write design documentation independently).
    • Understanding of systems design and architecture (enough to work with architects).
  • Strong written and verbal communication skills; ability to explain complex concepts to a wide variety of individuals with varying technical skills.
  • Strong understanding of Scrum and Agile.
    • Demonstrated ability to execute in an agile environment, especially Scrum and/or Kanban. This especially includes ability to estimate and meet deadlines, focus on priorities, understand goals and objectives, assist with planning.
    • Demonstrated ability to define backlog items in JIRA and assist with refinement of product backlogs.
  • Team player with demonstrated ability to:
    • Work well within a team.
    • Work independently.
    • Meet deadlines.
    • Independently learn new technologies.
    • Collaborate, take direction, take initiative, and drive efforts rather than waiting to be tasked and directed.
    • Thrive in a fast-paced environment.
  • Must be inquisitive and resourceful: network within the organizations to ask relevant questions; interact with peer team members, product managers, architects, and key stakeholders.
  • Must be able to handle sensitive and confidential information appropriately.

Preferred Skills and Experience

  • Experience in Amazon Web Services, especially S3, Lambda, RDS, and other cloud database services.
  • Experience in AWS GovCloud (FedRAMP).
  • Experience with conceptual, logical, and physical database modeling.
  • Experience with other relational database such as Oracle, SQL Server, or MySQL.
  • Familiarity with data warehouses and data lakes.
  • Experience with NoSQL technologies, especially DynamoDB.
  • Experience with enterprise messaging, especially message queues, workflows, API integration, Enterprise Application Integration (EAI) and Enterprise Service Bus (ESB).
  • Experience in serverless cloud technologies.
  • Exposure to full-stack development with React JS or other front-end JavaScript frameworks.
  • Experience with Service-Oriented Architecture (SOA) and/or Microservices Architecture (MSA) patterns.
  • Experience using static code analysis (SCA) tools such as Fortify and SonarQube.
  • Experience working in environments that utilize TDD-based automation.
  • Experience supporting public-facing web applications with a large user base.
  • Experience implementing high-volume claims and/or document scanning systems.
  • Proficiency in Bash, PowerShell, JavaScript, or other scripting languages.
  • Strong written communication and documentation experience.
  • Public contributions to GitHub and/or open-source projects.
  • Federal contracting experience.
  • The following certifications:
  • AWS Solutions Architect Associate (AWS SAA-C02/C03) 
  • AWS Certified Database Specialty (AWS DBS-C01)

COVID Policy: New employees will be required to adhere to the Company’s and its clients’ COVID-19 safety procedures. In the event that the COVID-19 vaccination mandate for Federal Contractors is enforced, you must become fully vaccinated or request and be approved for an exemption. Employees working onsite at a client location must comply with our client’s COVID-19 requirements.

GovCIO is a team of professionals who want to make a difference. And that can only happen with a diverse, happy, and cared-for team. So, we prioritize your well-being, equity for all and look for ways to make work a better place for each of us every day.

We are an Equal Opportunity Employer. All qualified applicants receive consideration for employment without regard to race, ethnicity, religious affiliation, gender, gender identity or expression, sexual orientation, national origin, or disability status. EOE AA M/ F/Vet/Disabled

Compensation Range (In compliance with Colorado's Equal Pay for Equal Work Act for remote or positions located in CO)

135,000

Apply Now

Not The Right Fit?

Is this not the job you’re looking for? That’s ok! We’ve got plenty of other opportunities for you to peruse. Search all of our open positions by your area of interest or location.

View All Jobs