Responsible for monitoring and uptime of all production databases.
Estimate Microsoft SQL or PostgeSQL database capacities, develop methods for monitoring database capacity and usage.
DUTIES AND RESPONSIBILITIES:
Essential Duties:
Responsible for the monitoring and uptime of all production databases
Estimate Microsoft SQL or PostgreSQL database capacities; develop methods for monitoring database capacity and usage.
Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any needed downtime.
Set database usage standards with developers.
Manage schema updates and code-driven DB changes with developers.
Participate in application development projects and be responsible for the database architecture and design.
Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.
Diagnose and troubleshoot database errors.
Other Duties:
Recommend and implement emerging database technologies.
Create and manage database reports, visualizations, and dashboards.
Recommend optimizations to existing application queries.
Provide oversight and manage MS SQL Server, AWS cloud-native RDBMS and NoSQL DBs for new product lines
Be a part of rotating on-call schedules.
Support complex web-based applications.
Perform other duties as assigned.
The preceding functions are examples of the work performed by employees assigned to this job classification. Management reserves the right to add, modify, change or rescind work assignments and make a reasonable accommodation as needed.
QUALIFICATIONS:
Skills:
Required:
Minimum 3 years of experience working with PostgreSQL or Microsoft SQL Server
3 years of experience as a PostgreSQL or Microsoft SQL database administrator designing and deploying PostgreSQL databases on Cloud platforms such as AWS and Azure
Experience with AWS and Azure RDS offerings and support
Experience with backups, restores and recovery models
3 years of expert experience performing database performance analysis, system and statement SQL tuning.
Advanced knowledge of database security, backup and recovery, and performance monitoring standards
Ability to work in the US for a Government Contractor
Desired:
Understanding of relational and dimensional data modeling
PowerShell and Unix shell scripting skills
Experience with Linux or Windows Server environments
Extensive experience with additional database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB)
Have extensive AWS and Azure RDS experience
Experience with NoSQL technologies
Education:
Required:
Bachelor’s degree in an applicable discipline
Combination of experience and education will be considered
Desired:
Advanced degree in an applicable discipline a plus
Certification(s), Licenses:
Required:
Any Applicable Certifications a plus
Desired:
Any Applicable Certifications a plus
Years of experience in a similar role:
Required:
3 + years
Desired:
5 + years
PHYSICAL DEMANDS (per observation of incumbents in this position):
Standing
20 % per day
Sitting
80 % per day
Walking
10 % per day
Stooping
5 % per day
Lifting
If traveling, ability to lift up to 50 lbs. unassisted (luggage, laptop etc.)
Up to 10 lbs. unassisted, several times a day (laptop, office equipment, office supplies, etc.)
Computer Work
80 % per day
Telephone Work
20 % per day
Reading
60 % per day
Other, please specify
Travel unassisted up to 10 % per year, via common carrier and/or personal automobile.
This role can be Remote which would allow most work to be performed at home; however, the Employer is a Federal Contractor and subject to federal vaccination mandate. Employees must be fully vaccinated to come onto any of DSS, Inc’s sites or Client sites.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
If you need an accommodation seeking employment with DSS, Inc., please email jobs@dssinc.com or call (561) 284-7373. Accommodations are made on a case-by-case basis.