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 yearsBackground: GDIT/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), GDIT/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, GDIT/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). GDIT/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.Job Summary:GDIT/CSRA is looking for an experienced Senior Oracle Database Administrator (Sr.
Oracle DBA) for the Client OBIM program in Arlington, VA. The ideal candidate will support, manage, and monitor mission critical IDENT Production and Non-Production databases in a fast-paced team environment. Specific responsibilities include but are not limited to:Patches, upgrades, and troubleshoots production and non-production databasesConducts performance tuning of indexes and optimization of storage functionalityReviews database design and integration of systemsProvides backup recovery and makes recommendations regarding enhancements and/or improvementsSupports development effort and production deployment releasesSynchronizes development, test, and production environment on a regular basisMonitors database activities and their resource utilizationMaintains security and integrity controlsMay work on-call rotation for application supportMay support overnight, late-night, early-morning, and/or weekend O&M activitiesMay provide support with technical documentationRequired Qualifications & Skills:Client HQ EOD required to start; must be able to obtain Client HQ Final SuitabilityBS and 5+ plus yrs. relevant experienceDemonstrated ability to work independentlyDesired Qualifications & Skills:BS or MS in computer science or information systems field of study9+ years' experience in database administrationOracle Certification(s)Experience working with large Oracle databases over 500TBExperience working with Oracle RAC databases 12cExperience installing, configuring, and managing Oracle Enterprise Manager (OEM) 12c Cloud ControlExperience installing/maintaining Oracle databases in AIX, Linux, and Windows operating systemsExperience in Oracle ASM, Data Guard, Oracle cloud control/ Grid Control (OEM) and RMANExperienced in high availability and disaster recovery solutions, including database failover and data center switchoverExperience in database and application performance tuningExperience with SQL and PL/SQL