Sr SQL Database Administrator

Job description

SQL Database Administrator

Remote




SUMMARY:

Founded in 2001, Indigo IT is an award-winning information technology consulting and services company.

We are a trusted services provider to government agencies seeking innovative Cloud, Cybersecurity, Knowledge Management, and Enterprise solutions.

We know our defense, federal, and civilian customers have critical IT infrastructures that must remain reliable, available, and maximized.

Indigo IT is mission focused and committed to maintaining a sense of urgency in anticipating and supporting our customers’ technology goals and objectives.

Our unique ability to think beyond today allows our clients to stay ahead of their IT challenges.

Recognized on the 2020 Inc.

5000 list of America’s fastest growing companies, we are always looking to hire top talent in the field - come join us today!



The CBP Data Center Support Services project provides comprehensive data center support to the CBP Office of Information Technology (OIT) in the area of Enterprise Infrastructure.

As a SQL Database Administrator, primary responsibilities will be to support the Database team in the administration, development, and testing, of database platforms supporting functions such as designing, implementing, and maintaining new databases, backup/recovery and configuration management.

Other responsibilities include installing database management systems (DBMS) and providing input for modification of procedures and documentation used for problem resolution and day-to-day maintenance.

This role will support efforts to accelerate development of automation scripts for deployment, configuration, security hardening and patch management of standard database and Web Service platforms



ESSENTIAL FUNCTIONS/RESPONSIBILITIES:


+ Working with other teams to consolidate database instances and storage using capacity and performance analysis tools to identify underutilized instances, duplicate copies of data and identify associated server, network and storage resources that can be “right sized”

+ Support the database engineering team in integrating, implementing, and operating OIT Database systems (Datacom/DB, IBM DB2, Microsoft SQL Server, and Oracle) across the entire enterprise and with cloud service providers to support 24x7x365 availability.

+ Conduct problem root cause analysis and isolate system problems utilizing diagnostic and system management tools (i.e. system dumps and system/component traces, monitoring tools, vendor problem data bases).

+ Maintain security hardened baseline configurations and deploy security (patches), software maintenance (patches) and new software releases and supporting products infrastructure as directed by the system owner, policy, or the Cybersecurity Directorate.

+ Support the engineering, integration, implementation, and operation of a virtualization strategy to include Database server consolidation, storage consolidation, and automation.

Automation includes seamless Database provisioning, and non-disruptive workflow/application/data migrations.

+ Maintain up-to-date documentation of all procedures, infrastructure diagrams, system configuration and baseline standards, implementation plans, system back out plans, system recovery plans, maintenance plans, system upgrades, and all system changes.

+ Support resolution of incidents and execution of approved change requests.

+ Design and implement automated responses to system issues (e.g., automatic failover, resource allocation adjustments).




SPECIFIC KNOWLEDGE, SKILLS, & ABILITIES:


+ Datacom/DB

+ IBM DB2

+ Microsoft SQL Server

+ Oracle DBMS

+ SQL Server Reporting Services (SSRS)

+ Ability to work rotating weekends & evening on-call support




EDUCATION, EXPERIENCE, & CERTIFICATIONS:


+ Active DoD Top Secret clearance OR CBP Background Investigation (preferred), US Citizenship with ability to obtain a federal Public Trust clearance (required)
+ Functions as a technical expert across multiple project assignments.

May supervise others.
+ A Senior labor category has over 10 years of experience and both a B.S. and M.S. degree.
+ A Senior labor category typically works on high-visibility or mission critical aspects of a given

program and performs all functional duties independently.
+ A Senior labor category may oversee the efforts of less senior staff and/or be responsible for the efforts of all staff assigned to a specific job.
+ Experience with PostgreSQL and MongoDB.
+ Database migration and upgrade experience.
+ SQL performance tuning, backup/recovery, replication, and clustering experience.
+ MCSE (SQL Server) and PostgreSQL Advanced Certification preferred certifications.









At Indigo IT, we offer an expansive benefits package for our employees, which includes: Medical, Dental, and Vision coverage options.

In addition, we offer 401(k) with company match, Group life and disability, Flex Spending Accounts (FSA), Paid Time Off (PTO), Paid holidays, and Education assistance.

We also have in house training programs for employees, we reward thought leadership with bonuses and recognition for publishing, speaking, and innovative thought leadership in our industry.





Indigo IT is committed to hiring and retaining a diverse workforce.

We are proud to be an Equal Opportunity/Affirmative Action Employer, making decisions without regard to race, color, religion, creed, sex, sexual orientation, gender identity, marital status, national origin, age, veteran status, disability, or any other protected class.

This employer uses E-Verify.

Required Skill Profession

Other General