Sr Sql Report Developer

Job Description

Description

The Office of Information Technology (OCIT)is looking for an accomplished Sr SQL Report Developer with strong Transact SQL skills to play a pivotal role. This position is responsible for the creation of reports in SSRS, Power BI and other reporting tools for large and complex existing databases.

Essential Duties and Responsibilities:

·         Extensive knowledge of T-SQL language

·         Strong knowledge and experience of stored procedure writing, query optimization, and indexes

·         Possess a strong functional expertise and understanding of the principles, practices, standards, terminology, protocols, and trends in database engineering and administration within large complex organizations

·         Analyze, develop, maintain and administer moderately complex MySQL, Oracle 19C and SQL Server 2016/2019 databases

·         Install and upgrade SQL Server software and other related tools

·         Knowledge of and experience with database management system, data mart, data warehouse, operational data store, and processing flowcharting techniques

·         Assist in setting and exercising standards and procedures for the effective utilization of the organization's SQL Server databases

·         Experience in using TOAD and/or Spotlight

·         Evaluate SQL Server features and related products

·         Understanding of SQL Server databases structures, theories, principles, and practices

·         Solid understanding of database design methods and data migration techniques

·         Knowledge of and experience with database security methods, procedures and best practices

·         Knowledge of applications development and support practices

·         Knowledge of techniques in defining logical relationships among data, processes, or events

·         Knowledge of principles and methods of network and server administration

·         Knowledge of and experience with developing and presenting technical documentation

·         Knowledge of information technology operating systems and hardware and software components

·         Knowledge of Pyspark/Python desirable.

Qualifications

Desirable Qualifications & Core Competencies

 

The ideal candidate will have the ability to quickly adapt to an environment to meet customer requirements.  The candidate will work closely with customer and must have strong communication skills.  The requirement is to be able to write complex Transact SQL queries/stored procedures.  The candidate will also train and mentor non-technical staff with writing SQL queries.  In addition, the ideal candidate will possess extensive experience and/or knowledge in the following competencies:

Candidates must have a BS and 5+ years of relative experience. We are able to accept 4+ years of additional experience in lieu of education. 

Candidates must be able and willing to complete a Drug Screen and LiveScan background investigation.

Technical Expertise

·         Extensive knowledge of T-SQL language

·         Strong knowledge and experience of stored procedure writing, query optimization, and indexes

• Extensive MS SQL database and SQL Reporting Services (SSRS) knowledge and development experience.
• Team-player with strong communication and interpersonal skills, possess a high degree of self-motivation and ability to work independently with minimal supervision.

Target salary range: $100,001 - $125,000. The estimate displayed represents the typical salary range for this position based on experience and other factors.

Covid Policy: SAIC does not require COVID-19 vaccinations or boosters. Customer site vaccination requirements must be followed when work is performed at a customer site.

Overview

SAIC® is a premier Fortune 500® technology integrator driving our nation's technology transformation. Our robust portfolio of offerings across the defense, space, civilian, and intelligence markets includes secure high-end solutions in engineering, digital, artificial intelligence and mission solutions. Using our expertise and understanding of existing and emerging technologies, we integrate the best components from our own portfolio and our partner ecosystem to deliver innovative, effective and efficient solutions that are critical to achieving our customers' missions.
We are approximately 24,000 strong; driven by mission, united by purpose, and inspired by opportunities. SAIC is an Equal Opportunity Employer, fostering a culture of diversity, equity, and inclusion, which is core to our values and important to attract and retain exceptional talent. Headquartered in Reston, Virginia, SAIC has annual revenues of approximately $6.9 billion. For more information, visit saic.com. For ongoing news, please visit our newsroom.