Serco Database Analyst IV - Reston, VA NC52141371 in Reston, Virginia

Database Analyst IV - Reston, VA NC52141371Reston, VA, US

Job Description Reviews, evaluates, designs, implements and maintains company database[s]. Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process. Writes codes for database access, modifications, and constructions including stored procedures. Familiar with a variety of the field's concepts, practices, and procedures. Leads and directs the work of others.

Key Activities:

-Data management and analysis, including daily data updates, review, and evaluation; query and stored procedures revisions; data scrubbing; code modifications and constructions.

-Design, implementation, and enhancement of operational progress reports; as well as review/quality inspection of daily and adhoc reports.

-Support of outbound call campaigns through design, implementation, and maintenance of database tables used with responses gathered via front end web-based application.

Other Activities:

-Request for Changes submittal and presentation to the Change Control Board.

-Service request monitoring, scheduling, updating.

-Data flow diagrams, technical requirements and practice, procedure, process documentation.

Required Skills Requires a bachelor's degree in area of specialty or equivalent and 6-8 years of experience in the field or in a related area.

Key Skills:

-SQL Server / Database Development / Administration

-T-SQL Queries,T-SQL Procedures,T-SQL Views, T-SQL Functions, T-SQL Triggers, T-SQL OLE Automation Objects, DBCC commands, SQL Management Studio, DTS, SSIS, Report Services, SQL Data Warehouse

-Ability to articulate execution plans, create partitions, determine long running queries and optimization

-Experience with backups, restores

-Experience with replication (reporting), DR capabilities

-Experience with indexed views, proper indexing schemes

-Ability to determine blocking, understand statistics, and fragmentation

Other Skills:

-.NET framework, Entity framework

-C#, VB.Net

-Lifecycle development of web applications

Employment Type Full time

Career Level Mid Career

Job ID 52141371

Company Serco Inc. (Serco) is the Americas division of Serco Group, plc, one of the world’s leading and most admired service companies. Serco serves Federal, state and local governments, along with the Canadian government and commercial customers. We help our clients deliver vital services more efficiently, while increasing the satisfaction of their end customers. Headquartered in Reston, VA, Serco has approximately 10,000 employees with an annual revenue of $1 billion and is part of a $6 billion global business that helps transform government and public services around the world. Serco recognizes that our employees are our most valuable asset. Our successes directly relate to our employees. At Serco, we listen, respect and support our employees and through continuous training, development and information-sharing, we advance talent internally, enhancing career growth and progression which enables not only our employees to excel but enables our customers to excel as well. Our employees personally can make a difference. It is not just a job at Serco; at Serco, we offer career opportunities. We invite you to become part of our dynamic team. Serco's people share a passion for delivering ethical service, innovation, and a commitment to results. Our focus on Bringing Service to Life is more than a tagline, it’s the way we get things done, the way we talk with each other, and the way we interact and respect each other. We succeed by encouraging and generating new ideas. We trust our people to deliver. We are passionate about building innovative and successful Serco businesses. Our most powerful tool in improving performance is to instill a stimulating culture where people feel they can personally make a difference. Serco is an equal opportunity employer committed to diversifying its workforce (Race/ Color/ Sex/ Sexual Orientation/ Gender Identity/ Religion/ National Origin/ Disability/ Vets).

Functional Area IT Infrastructure

Department With a core customer set that includes Health and Human Services (HHS) and Centers for Medicare and Medicaid Services (CMS), the CMS business unit is focused on providing world-class, technology-enabled support services to government organizations, helping them administer health care programs to the public. They unit delivers document processing, outbound call centers, business process design and software, application verification, and benefits determination and processing. The team delivers flexible and responsive solutions to evolving and emerging needs, a deep understanding of eligibility determination, exemptions and inconsistency processes, and knowledge of existing application processing.