SQL DATABASE DEVELOPER WITH SECURITY CLEARANCE
AlphaSix
Washington DC 20001 US
SQL Database Developer Clearance Requirement : Active Top-Secret, with SCI eligibility and ability to obtain a polygraph.
Location: Washington, D.C. Flexible for occasional telework – must be local to work location. Roles & Responsibilities • Provide SQL Server/Database development and administration support in fast moving, secure, DevOps environment.
• Provide engineering/operational maintenance and upgrades for SQL Servers, databases and a data warehouse to include: developing custom scripts to automate various database management processes, monitoring and tune 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, to include 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 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 recommends 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. Education & 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
• You have three (3) to five (5) years of experience designing, engineering, and administering SQL Server or Oracle databases.
• You have three (3) to five (5) years of experience creating complex queries, stored procedures, functions, and reports using SQL or Oracle.
• You have 3 years of experience with Data Modeling.
• You have 5 years of experience with SSIS.
• You have 3 years of experience with Microsoft PowerShell and Power-BI
• Data Modeling, either SQL or Oracle.
• Data warehouse architecture, implementation, and O&M
• Microsoft PowerShell and Power-BI
• High-availability, fail overs, backups, scaling and clustering operational systems
• Splunk 8.0 or later
• SharePoint
• Service Fabric
• OpenText
• Leveraging Azure and/or AWS cloud services
• ElasticSearch About AlphaSix Corporation AlphaSix Corporation is a Washington, DC-based small business that provides Federal, state, and local governments with a broad range of IT products, solutions, and services focused on the convergence of big data and cyber security. At AlphaSix, we pride ourselves in providing a highly energized work environment where our employees are rewarded with competitive compensation packages and excellent benefits. We understand that to attract the top talent in the industry and provide the highest level of satisfaction to our customers, we need to provide an environment that supports our employees in their efforts to fulfill the needs of their clients and allows them to reach their fullest potential. AlphaSix offers a variety of benefits including competitive compensation, health insurance, disability coverage, 401(k) with matching program, paid holidays, and PTO.
Location: Washington, D.C. Flexible for occasional telework – must be local to work location. Roles & Responsibilities • Provide SQL Server/Database development and administration support in fast moving, secure, DevOps environment.
• Provide engineering/operational maintenance and upgrades for SQL Servers, databases and a data warehouse to include: developing custom scripts to automate various database management processes, monitoring and tune 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, to include 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 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 recommends 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. Education & 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
• You have three (3) to five (5) years of experience designing, engineering, and administering SQL Server or Oracle databases.
• You have three (3) to five (5) years of experience creating complex queries, stored procedures, functions, and reports using SQL or Oracle.
• You have 3 years of experience with Data Modeling.
• You have 5 years of experience with SSIS.
• You have 3 years of experience with Microsoft PowerShell and Power-BI
• Data Modeling, either SQL or Oracle.
• Data warehouse architecture, implementation, and O&M
• Microsoft PowerShell and Power-BI
• High-availability, fail overs, backups, scaling and clustering operational systems
• Splunk 8.0 or later
• SharePoint
• Service Fabric
• OpenText
• Leveraging Azure and/or AWS cloud services
• ElasticSearch About AlphaSix Corporation AlphaSix Corporation is a Washington, DC-based small business that provides Federal, state, and local governments with a broad range of IT products, solutions, and services focused on the convergence of big data and cyber security. At AlphaSix, we pride ourselves in providing a highly energized work environment where our employees are rewarded with competitive compensation packages and excellent benefits. We understand that to attract the top talent in the industry and provide the highest level of satisfaction to our customers, we need to provide an environment that supports our employees in their efforts to fulfill the needs of their clients and allows them to reach their fullest potential. AlphaSix offers a variety of benefits including competitive compensation, health insurance, disability coverage, 401(k) with matching program, paid holidays, and PTO.