Peraton
SQL Database Developer
Peraton, Washington, District of Columbia, us, 20022
SQL Database Developer
Job Locations:
US-DC-WashingtonRequisition ID:
2024-149157
Position Category:
Information Technology
Clearance:
Top Secret/SCI w/Poly
Responsibilities
Technology is constantly changing, and our adversaries are digitally exceeding law enforcement's ability to keep pace. Those charged with protecting the United States are not always able to access the evidence needed to prosecute crime and prevent terrorism. The Government has trusted in Peraton to provide the technical ability, tools, and resources to bring criminals to justice. In response to this challenge, Peraton is seeking a talented Database Developer with senior-level expertise in SQL Server and Database Development to provide support on a law enforcement mission critical system.Provide SQL Server/Database development and administration support in a fast-moving, secure, DevOps environment.Provide engineering/operational maintenance and upgrades for SQL Servers, databases, and a data warehouse, including developing custom scripts to automate various database management processes, monitoring and tuning the systems to achieve optimum DB/DW performance levels; developing, optimizing, and tuning stored procedures, functions, triggers, views, and queries in support of the client's business intelligence and analytic applications.Maintain and improve the database schema, database design, and transition development activities.Resolve various database issues, including problems with data modeling, design, queries, security control, backup/restore, disaster recovery, and import/export data, as well as coordinate with data ingest efforts.Be proficient in T-SQL from development to administration.Use Microsoft Enterprise SQL features such as Always On, SSRS, and SSIS (data warehousing).Support SQL development including creating and designing SSRS Reports, SSIS Packages, and Team Foundation Server with Visual Studio.Perform Database Design and Data Cleansing with SSIS and ETL with different data sources.Collaborate with the Application Development team, Testing team, other IT departments, and subject matter experts to improve database/data warehouse performance.Maintain and monitor third-party product and custom databases.Conduct hardware and software audits of servers and databases to ensure compliance with established standards, policies, and configuration guidelines.Develop, implement, and promote standard operating procedures and schedules. Research and recommend process improvements and industry best practices.Schedule installations, upgrades, and patches in accordance with IT policies and procedures.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.Qualifications
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.Three (3) to five (5) years of experience designing, engineering, and administering SQL Server or Oracle databases.Three (3) to five (5) years of experience creating complex queries, stored procedures, functions, and reports using SQL or Oracle.Three years of experience with Data Modeling.Five years of experience with SSIS.Three years of experience with Microsoft PowerShell and Power-BI.Data Modeling experience, either SQL or Oracle.Data warehouse architecture, implementation, and O&M.High-availability, fail overs, backups, scaling, and clustering operational systems.Experience with Splunk 8.0 or later, SharePoint, Service Fabric, OpenText, leveraging Azure and/or AWS cloud services, and ElasticSearch.Peraton offers enhanced benefits to employees working on this critical National Security program, which include heavily subsidized employee benefits coverage for you and your dependents, 25 days of PTO accrued annually up to a generous PTO cap, and eligibility to participate in an attractive bonus plan.Peraton Overview
Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world's leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains: land, sea, space, air, and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces. Each day, our employees do the can't be done by solving the most daunting challenges facing our customers. Visit peraton.com to learn how we're keeping people around the world safe and secure.Target Salary Range
$135,000 - $216,000. This represents the typical salary range for this position based on experience and other factors.
#J-18808-Ljbffr
Job Locations:
US-DC-WashingtonRequisition ID:
2024-149157
Position Category:
Information Technology
Clearance:
Top Secret/SCI w/Poly
Responsibilities
Technology is constantly changing, and our adversaries are digitally exceeding law enforcement's ability to keep pace. Those charged with protecting the United States are not always able to access the evidence needed to prosecute crime and prevent terrorism. The Government has trusted in Peraton to provide the technical ability, tools, and resources to bring criminals to justice. In response to this challenge, Peraton is seeking a talented Database Developer with senior-level expertise in SQL Server and Database Development to provide support on a law enforcement mission critical system.Provide SQL Server/Database development and administration support in a fast-moving, secure, DevOps environment.Provide engineering/operational maintenance and upgrades for SQL Servers, databases, and a data warehouse, including developing custom scripts to automate various database management processes, monitoring and tuning the systems to achieve optimum DB/DW performance levels; developing, optimizing, and tuning stored procedures, functions, triggers, views, and queries in support of the client's business intelligence and analytic applications.Maintain and improve the database schema, database design, and transition development activities.Resolve various database issues, including problems with data modeling, design, queries, security control, backup/restore, disaster recovery, and import/export data, as well as coordinate with data ingest efforts.Be proficient in T-SQL from development to administration.Use Microsoft Enterprise SQL features such as Always On, SSRS, and SSIS (data warehousing).Support SQL development including creating and designing SSRS Reports, SSIS Packages, and Team Foundation Server with Visual Studio.Perform Database Design and Data Cleansing with SSIS and ETL with different data sources.Collaborate with the Application Development team, Testing team, other IT departments, and subject matter experts to improve database/data warehouse performance.Maintain and monitor third-party product and custom databases.Conduct hardware and software audits of servers and databases to ensure compliance with established standards, policies, and configuration guidelines.Develop, implement, and promote standard operating procedures and schedules. Research and recommend process improvements and industry best practices.Schedule installations, upgrades, and patches in accordance with IT policies and procedures.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.Qualifications
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.Three (3) to five (5) years of experience designing, engineering, and administering SQL Server or Oracle databases.Three (3) to five (5) years of experience creating complex queries, stored procedures, functions, and reports using SQL or Oracle.Three years of experience with Data Modeling.Five years of experience with SSIS.Three years of experience with Microsoft PowerShell and Power-BI.Data Modeling experience, either SQL or Oracle.Data warehouse architecture, implementation, and O&M.High-availability, fail overs, backups, scaling, and clustering operational systems.Experience with Splunk 8.0 or later, SharePoint, Service Fabric, OpenText, leveraging Azure and/or AWS cloud services, and ElasticSearch.Peraton offers enhanced benefits to employees working on this critical National Security program, which include heavily subsidized employee benefits coverage for you and your dependents, 25 days of PTO accrued annually up to a generous PTO cap, and eligibility to participate in an attractive bonus plan.Peraton Overview
Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world's leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains: land, sea, space, air, and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces. Each day, our employees do the can't be done by solving the most daunting challenges facing our customers. Visit peraton.com to learn how we're keeping people around the world safe and secure.Target Salary Range
$135,000 - $216,000. This represents the typical salary range for this position based on experience and other factors.
#J-18808-Ljbffr