SQL Database Developer

$135,000 - $216,000/Yr

Peraton - Washington, DC

Full-time - Mid Level

Washington, DC

Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services

About the position

Peraton is seeking a talented Database Developer with senior-level expertise in SQL Server and Database Development to support a law enforcement mission critical system. The role involves providing technical ability, tools, and resources to help bring criminals to justice in a fast-paced, secure, DevOps environment.

Responsibilities

• Provide SQL Server/Database development and administration support in a secure, DevOps environment.
• Perform engineering/operational maintenance and upgrades for SQL Servers, databases, and a data warehouse.
• Develop custom scripts to automate various database management processes.
• Monitor and tune systems to achieve optimum database/data warehouse performance levels.
• Develop, optimize, and tune stored procedures, functions, triggers, views, and queries for business intelligence and analytic applications.
• Maintain and improve the database schema and design.
• Resolve various database issues including data modeling, design, queries, security control, and disaster recovery.
• Be proficient in T-SQL from development to administration.
• Use Microsoft Enterprise SQL features such as Always On, SSRS, and SSIS.
• Support SQL development including creating and designing SSRS Reports and SSIS Packages.
• Perform Database Design and Data Cleansing with SSIS and ETL with different data sources.
• Collaborate with the Application Development team, Testing team, and other IT departments to improve database performance.
• Maintain and monitor third-party product and custom databases.
• Conduct hardware and software audits of servers and databases for compliance.
• Develop, implement, and promote standard operating procedures and schedules.
• Schedule installations, upgrades, and patches according to IT policies.
• Ensure data/media recoverability by supporting scheduled system backups and database archive operations.
• Ensure systems documentation and configuration management records are current.
• Be resourceful, a problem solver, and methodical.

Requirements

• Minimum of 8 years with BS/BA; Minimum of 6 years with MS/MA; Minimum of 3 years with PhD.
• Active TS clearance, possess SCI eligibility and the ability to obtain a polygraph.
• Experience with programming and database management including scripting.
• 3 to 5 years of experience designing, engineering, and administering SQL Server or Oracle databases.
• 3 to 5 years of experience creating complex queries, stored procedures, functions, and reports using SQL or Oracle.
• Experience with Data Modeling.
• Experience with SSIS.
• 3 years of experience with Microsoft PowerShell and Power-BI.
• Experience with data warehouse architecture, implementation, and O&M.
• Experience with high-availability, failovers, backups, scaling, and clustering operational systems.
• Familiarity with Splunk 8.0 or later, SharePoint, Service Fabric, OpenText, Azure and/or AWS cloud services, and ElasticSearch.

Benefits

• Heavily subsidized employee benefits coverage for you and your dependents.
• 25 days of PTO accrued annually up to a generous PTO cap.
• Eligible to participate in an attractive bonus plan.