Database Administrator II

Array Information Technology Fairfax , VA 22038

Posted 3 days ago

Database Administrator II

Job Responsibilities:

  • Create and maintain all databases required for development, testing, training and production usage

  • Perform the capacity planning in collaboration with System Administrators

  • Perform ongoing tuning of the database instances

  • Install new versions of the SQL Server and its tools

  • Plan and implement backup and recovery of the SQL Server database

  • Control migrations of programs, database changes, reference data changes and critical patch updates through the development life cycle

  • Implement and enforce security for all of the SQL Server Databases

  • Administer all database objects, including tables, clusters, indexes, views, sequences, packages and procedures

  • Assist with impact analysis of any changes made to the database objects; troubleshoots problems regarding the databases, applications and development tools and provides technical support to application development teams and Tier 1/2 helpdesk

  • The DBA has ultimate responsibility for the physical database implementation

  • Experience with writing Windows Server and Red Hat Linux scripts and T-SQL

  • Experience in using the Remedy system for initiating, updating and closing Remedy trouble tickets at Tier 5.

Qualifications:

  • B.S. Information Systems or equivalent with 5+ years' experience, providing Database Administration (DBA), of development/test/ sandbox/production servers in contractor and Government environments to include Microsoft SQL Server Database COTS technologies.

  • Security +. Microsoft Certified Solutions Associate (MCSA)

  • Secret clearance

ARRAY Information Technology, Inc. is committed to hiring and retaining a diverse workforce. We are proud to be an Equal Opportunity/Affirmative Action-Employer, making decisions without regard to race, color, religion, creed, sex, sexual orientation, gender identity, marital status, national origin, age, veteran status, disability, or any other protected class.


Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Database Administrator

George Mason University

Posted 3 days ago

VIEW JOBS 7/17/2018 12:00:00 AM 2018-10-15T00:00 Information Technology Specialist II The George Mason University Center for Evidence-Based Crime Policy (CEBCP), housed within the Department of Criminology, Law and Society, invites applications for Database Administrator to work in the Washington/Baltimore High Intensity Drug Trafficking Areas (WBHIDTA) program. The CEBCP, founded in 2008, seeks to make scientific research a key component in decisions about crime and justice policies. The CEBCP carries out this mission by advancing rigorous studies in criminal justice and criminology through research-practice collaborations, and proactively serving as an informational and translational link to practitioners and the policy community. George Mason University has a strong institutional commitment to the achievement of excellence and diversity among its faculty and staff, and strongly encourages candidates to apply who will enrich Mason's academic and culturally inclusive environment. The HIDTA Program is a federal grant program administered by the White House Office of National Drug Control Policy (ONDCP) to provide resources that assist federal, state, local and tribal agencies to coordinate activities that address drug trafficking in specifically designated areas of the United States. Information and intelligence sharing are keys to successful investigations, drug treatment and prevention programs, and drug policy development. The Mapping & Data Services Unit of the Washington/Baltimore HIDTA is responsible for data warehousing including organization and support of analytical data within the program. This position is based in Greenbelt, MD. Responsibilities: This position will be directly responsible to ensuring data critical to our mission is properly stored and utilized in order to support the needs of our applications and analysts. In addition to this, the position will be responsible for working with our ESRI GIS system infrastructure, which is heavily dependent on our database infrastructure. This position will be responsible for:* Extraction, transformation and loading (ETL) of data from various data sources (both internal and external) into our analytical warehouse. This involves the use of various scripting languages such as SQL, Python & Java (and others where appropriate)* Configuration of various analytical software that consumes our warehouse * Fulfilling data requests from our Investigative Support Center (ISC)* Creating reports using SQL Reporting Services* Maintaining the database integrity of our Overdose Detection Mapping Application (ODMAP) map utility * Supporting other applications that consume data warehouse & GIS services such as Case Explorer* Maintaining the tuning, indexing and performance of our existing database infrastructure* Maintaining and supporting the ESRI GIS platform Required Qualifications: * Bachelor's in Computer Science, Information Systems or related field, or equivalent combination of education and experience; * Must be able to pass National Security background check and obtain a Secret Level security clearance.* Experience performing ETL transactions from custom data sets to structured warehouse formats. * Strong grasp of SQL query language * Experience in administration of Microsoft SQL Server, including database user management, database tuning, database indexing, database replication, database migration* Experience using reporting services such as Crystal, Active Reports or SQL Server reporting services. * Must be able to safely and independently lift and move PCs and related computer equipment. Preferred Qualifications: * ESRI GIS Platform; * Microsoft SQL Server Reporting services; and * Python, and/or Java scripting experience. George Mason University Fairfax VA

Database Administrator II

Array Information Technology