Cloud Database Engineer (Remote) #3539

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?

 

Overview

 

GovCIO is looking for a highly motivated database developer with the ability to learn quickly and act independently. Technical depth in AWS Aurora PostgreSQL and Amazon Cloud is critical for this role. Knowledge of Microsoft SQL Server is helpful for short-term migration. Software development, data engineering, and cloud engineering strongly preferred over traditional database administration skills. Must have strong coding skills (not just SQL but general language such as Python). This a developer and cloud engineering role, not a database administrator position. We strongly prefer developers certified in AWS Cloud—or at least actively pursuing certifications. We will actively support your career path in that area.

 

With a focus on software engineering and quality, you will collaborate with product owners, developers, and designers to provide the best value to our customers. You will internally help improve software engineering practices for the entire team. GovCIO is expanding its development organization in support of a continuously expanding portfolio of solutions. We leverage current and emerging services offered by both AWS and Azure. Our roadmap is evolving as we work to identify and continuously deliver transformative capabilities for both our internal and external customers. 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.
  • Migrate SQL Server T-SQL in AWS RDS to Aurora PostgreSQL.
  • 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.
  • Secure and protect private personal and health information.
  • Collaborate using development practices such as trunk-based development, feature toggles, automated testing, frequent pull requests, and continuous deployment pipelines.
  • Work in a multi-disciplined team including human-centered designers, frontend specialists, DevOps engineers, and other software engineers.
  • Work with Product Owners and Scrum Teams in requirements decomposition, backlog refinement, breakdown of user stories and tasks.
  • Write unit and integration tests to ensure systems meet business needs.
  • 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).

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. 5 or more years’ professional software development experience.
  • 3 or more years’ experience in postgreSQL.

Required Skills and Experience

  • Ability to thrive in a fast-paced, tight deadline delivery timeline.
  • Aptitude to independently learn new technologies.
  • 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 administering multi-terabyte databases.
  • Experience in analyzing query execution plans, and profiling.
  • Experience in PowerBI and/or SQL Server Reporting Services (SSRS).
  • Experience in ETL/ELT approaches.
  • Experience with Aurora, AWS RDS, AWS DMS, S3, and CloudWatch.
  • Experience with SQL/database source control in Git.
  • Familiarity with Python.
  • Familiarity with Redshift, data warehouses, and data lakes.
  • Must be strong in the following areas: Troubleshooting, especially root cause analysis and defect isolation.
  • Out of the box thinking.
  • Must be able to think multiple solutions to the same problem.
  • Written and verbal communication along with proven fluency of English.
  • Interpersonal and collaboration skills such as active listening, constructive feedback, teamwork, building relationship and trust with both teammates and the customer.
  • Sprint planning, user story refinement (grooming), defining/verifying acceptance criteria, definition of done, and design walkthroughs to inject quality early in the development life cycle.

Preferred Skills and Experience

  • Experience in Python.
  • 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. 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 with the Git command line.
  • Proficiency in Bash, PowerShell, JavaScript, or other scripting languages.
  • Strong written communication and documentation experience.
  • Public contributions to GitHub and/or open-source projects.
  • VA or 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)

$140,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