Database Specialist – Level IIProvides all activities related to the administration of computerized databases. Able to communicate with management, technicians, and end-users to evaluate need prior to development of an automated solution. Prepares detailed reports which might include system requirements such as concurrent usage factors, data storage requirements, response rates, and discuss procedures for processing data through the use of data base management systems (DBMS) including relational data bases. Projects long-range requirements for database administration and design in conjunction with other managers in the information systems function. Designs, creates, and maintains databases in a client/server environment. Conducts quality control and auditing of databases in a client/server environment to ensure accurate and appropriate use of data.
Advises users on access to various client/server databases. Designs, implements, and maintains complex databases with respect to access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods. Applies knowledge and experience with database technologies, development methodologies, and front-end (e.g., COGNOS)/back-end programming languages (e.g., SQL). Performs database programming and supports systems design. Includes maintenance of database dictionaries, overall monitoring of standards and procedures, file design and storage, and integration of systems through database design. Evaluates data base design tradeoffs, impacts on user expectations, performance levels, and space allocation requirements.Education & Experience LevelsLevel - Knowledge/Skill Description - Minimum Education - and/or - Minimum ExperienceII - Possesses and applies expertise on multiple complex work assignments which are broad in nature, requiring originality and innovation in determining how to accomplish tasks.
Has the ability to apply a comprehensive knowledge across key tasks and high impact assignments. Plans and leads major technology assignments. Evaluates performance results and recommends major changes affecting short-term project growth and success. Functions as a technical expert across multiple project assignments. May supervise others. - Associate's Degree or higher - and/or - 5-15 yearsJob Description:CSRA, a Federal marketplace leader in next-generation IT solutions and professional services, is seeking highly qualified and motivated IT professionals like you who are eager to contribute to our critical Homeland Security missions.
For the Department of Homeland Security (Client), Office of Biometric Identity Management (OBIM, formerly US-VISIT), CSRA performs operations and maintenance (O&M) of the Automated Biometric Identification System's (IDENT) production and non-production environments and associated business systems. In support of this effort, CSRA provides Task Order Management, Datacenter Operations, Disaster Recovery/Continuity of Operations, System Management and Monitoring, Service Request Management, Technology Analysis, and Non-production Support (to include Program Support Systems and Transition). CSRA is excited to offer you a unique opportunity to join a best performing O&M team supporting one our nation's most critical homeland missions – the storage and processing of biometric and associated biographic information for national security, law enforcement, immigration and border management, intelligence, background investigations, and associated testing, training, management reporting, planning and analysis. CSRA is looking for a Database Specialist / Administrator to support the Operational Data Store (ODS) environment and the implementation and maintenance of business intelligence capabilities, including but not limited to: cloud-based business intelligence and analytics; extract, transform, load (ETL) business logic; data warehouse technology; and various databases and servers.Essential Responsibilities:Installing, configuring, deploying, administering, maintaining, tuning, and upgrading databases on an Amazon Web Services platformInstalling, configuring, deploying, administering, maintaining, tuning, upgrading and monitoring enterprise Relational, In-memory, NoSQL, and Object Store databasesInstalling, configuring, deploying, administering, maintaining, tuning, upgrading and monitoring Informatica PowerCenter and PowerExchange with CDCInstalling, configuring, deploying, administering, maintaining, tuning, upgrading and monitoring Birst Business Intelligence and Data Analytics server softwareDeveloping static reports and dashboards from operational data contained in enterprise databases using Birst, using a variety of graphical report typesConfiguring database- and table-level encryption of data-at-restRequired Skills / Qualifications:Associate's Degree in a relevant field and/or 5-15 years of relevant experienceExperience installing, configuring, deploying, administering, maintaining, tuning, upgrading and monitoring a relational databases (Oracle 12c RDBMS, MySQL, Microsoft SQL Server, and/or PostgreSQL)Experience installing, configuring, deploying, administering, maintaining, tuning, upgrading and monitoring Informatica PowerCenter and PowerExchange with CDCExperience utilizing Informatica PowerExchange with CDC to perform data synchronization efforts, functionalities, and tasksExperience utilizing Informatica PowerCenter and PowerExchange with CDC to perform data extraction, transformation, and loading efforts, functionalities, and tasksExperience with NoSQL technologies like DynamoDB, Redis, MongoDB, Cassandra or Riak.Experience with Birst Business Intelligence and Data Analytics server software and report developmentDesired Skills / Qualifications:Bachelor's degree or equivalent plus five (5) years related experience, or Master's degree plus three (3) years related experienceCertification in one or more of the following:Oracle Database Certified Associate (OCA) levelMongoDB Certified DBA or MongoDB Certified Developer, Associate LevelMicrosoft Certified Solutions Associate (MCSA): Microsoft SQL Server, with a Microsoft Certified SolutionsExpert (MCSE): PostgreSQL Associate Level CertificationThis is a Contract to hire opening and hourly rate is open all inclusive but conversion salary needs to be at $105K plus benefits. Only US Citizen are applicable for this position.