Sr. Database Developer

Planet Technologies, the Nation’s leading Microsoft services provider to the public sector, is looking for a highly motivated individual to join our growing team as a Sr. Database Developer. In this role, you will be supporting impactful project that make a difference for our country.Responsibilities

This role is a mix of DB Developer and DBA. Must be flexible and able to complete both aspects, i.e. DB Developer/DBA.

Responsible for the design, programming, construction, and implementation of new databases, as well as modifying existing databases for platform updates and changes in user needs - we use SQL and Postgres.

Point-In-Time restore backups are stored for last 7 days.

Weekly backups are retained for 5 weeks.

Monthly backups are retained for every 12 months.

Yearly backup of 25th week of each year for 10 years.

There is a differential backup taken every 12 hours

Once the period of retention expires the older backups are no longer available.

DR is in a constant read only mode in West unless East goes down, then it flips to Read/Write - same policies

Control DBs by monitoring and approving DB changes or new development

Monitoring and automating indexes to keep DB high performance

Understands Azure or AWS managed SQL Servers

Works closely with Azure Engineer

Essentials

Clearance: Active Top-Secret clearance is required

Location: 2 days per week in Washington DC

#CJ