Sr Database Administrator
- Defense Business Systems (DBS) Life Cycle Management
- Acquisition
- Sustainment
- Maintenance
- Technical Support
- Provide all activities related to the administration of computerized databases
- Project long-range requirements for database administration and design in conjunction with other managers in the information systems function
- Design, create, and maintain databases in client/server environment and other required environments
- Design, implement, and maintain complex databases with respect to JCL, access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods
- Apply knowledge and experience with database technologies, development methodologies, and front-end/back-end programming languages (e.g., SQL)
- Perform database programming and support systems design
- Assist in database modeling as requested, offering design options/solutions
- Conduct quality control and auditing of databases in client/server environment to ensure accurate and appropriate use of data
- Advise users on access to various client/server databases
- Include maintenance of database dictionaries, overall monitoring of standards and procedures, file design and storage, and integration of systems through database design
- Develop database-related processes/procedures that enforce/complement other data integrity processes and procedures implemented by DIW
- Research, analyze, and determine Database Management System (DBMS) software/patch/upgrade availability and applicability
- Research and recommend software/hardware requirements to the government for approval
- Customize installations for application sustainment
- Develop implementation plan and schedule
- Obtain Government POC approval for installation schedule
- Coordinate schedule through configuration management with the PMO who will go through the DLA Enterprise CM process
- Install/Configure DBMS software/upgrades/patches where applicable
- Provide database CERT/CTO/IA directives/mandates/regulations management where applicable
- Research, analyze, determine applicability and impacts of DBMS CERTS, CTOs, IA directives/mandates/regulations
- Develop implementation plan and schedule for security compliance
- Obtain customer approval for installation schedule from the PMO
- Coordinate schedule through configuration management and obtain approval
- Install and implement CERTS, CTOs, other IA directives, mandates and regulations including Security Technical Implementation Guides (STIGs) and Security Readiness Reviews (SRRs)
- Prepare Plans of Action and Milestones (POAMs) as required and implement mitigation measures/strategies as required
- Provide database backups and recoveries where applicable
- Determine, set up, coordinate backup schedule for DBMS and other related files
- Provide database Continuity of Operations (COOP) where applicable
- Participate in all phases of COOP planning as needed
- Participate in COOP exercises and related activities as required
- Prepare documentation for COOP exercise and related activities
- Administer application databases across DISA, J64 TFS and Azure GovCloud, and any future Amazon Cloud service
- Assist HP and DIW system administrators as required
- Provide both local and remote maintenance support to various operational systems deployed at more than one location
- Run queries and develop reports from databases
- Perform data cleansing of production database data
- Assist DIW customers as requested with data management concerns/issues/problems
- Provide support to DIW in the assessment and implementation of concepts and technologies regarding data mining, data warehousing, data standardization, data management and data administration
- Develop policies, processes and procedures for effective data management and administration
- Assist with SQL Server Reporting Services database configuration and setup when needed, including troubleshooting SSRS issues
- Provide project management services and support for DBMS and DBA related projects and efforts
- Prepare requested documentation such as lists, word documents, spreadsheets, POAMs, Work Breakdown Schedules (WBS)
- Track status and progress and report both formal and informal progress to government personnel and management
- Assist stakeholders in resolving issues/concerns/problems as they relate to database access and availability
- Interface with clients to determine database requirements
- Provide technical guidance and recommendations
- Support application development teams with database needs
- 10 years of progressive experience with database query languages such as Oracle, PL/SQL, SQL Server, and MS Access
- 10 years of hands-on experience and expertise in Relational Database Management Systems
- Experience in at least two projects in a large organization responsible for administering, operating, maintaining, and securing large-scale computer databases with Oracle, SSRS, and SQL Server
- Skills Required:
- Expert-level proficiency in Oracle database administration
- Advanced PL/SQL and SQL Server skills
- SSRS (SQL Server Reporting Services) configuration and troubleshooting
- Experience with MS Access
- Expertise in Relational Database Management Systems (RDBMS)
- Capability to work on various operating systems
- Knowledge of additional programming languages
- Database modeling and architecture design
- Performance tuning and optimization
- Database security implementation and management
- Quality control and auditing of databases
- Experience with DISA environments
- Familiarity with J64 TFS and Azure GovCloud platforms
- Understanding of database backup and recovery procedures
- Experience with database CERT/CTO/IA compliance management
- Knowledge of Security Technical Implementation Guides (STIGs)
- Proficiency in data management, cleansing, and reporting
- Experience with database dictionaries and standards monitoring
- Ability to develop database-related processes and procedures
- Strong analytical and problem-solving skills
- Excellent communication skills for advising users on database access
- Ability to work independently and as part of a team
- Experience with configuration management processes
- Knowledge of DoD/DLA processes, policies, and procedures
- Understanding of Section 508 compliance requirements
- Proficiency with Microsoft Office suite for documentation
- Education Required: Bachelor's degree in information technology related field with 10 years of relevant experience
- Education Preferred:
- Master's degree in Computer Science, Information Systems, Database Management, or related field
- Advanced database certifications beyond baseline requirements
- Certifications Required:
- DoD 8570/8140 certification as applicable for IT-II Critical Sensitive position (Information Assurance certification)
- Relevant database certifications (Oracle, SQL Server) from nationally recognized technical authorities
- All certifications must be current and maintained throughout the period of performance
- Certifications Preferred:
- Oracle Certified Professional (OCP) - Database Administrator
- Microsoft Certified Solutions Expert (MCSE): Data Management and Analytics
- Oracle Database 12c/19c Administrator Certified Professional
- Microsoft SQL Server certifications
- ITIL Foundation or higher
- CompTIA Security+ or higher
- US Citizenship and the ability to obtain and maintain an active Secret or higher clearance, per contract requirements.
Recommended Jobs
General Production
General Production I have a company that is know to have lots of OT to offer looking for the night owls . ( 3rd shift ) Company Profile Pioneering modern storage systems since 1954, when this…
Restaurant Manager
Restaurant Dining Room Manager We are seeking an experienced Restaurant Manager to lead the front-of-house operations of our upscale, full-service restaurant. This individual will be responsible f…
Branch Manager, Producing
POSITION SUMMARY: The Producing Branch Managers primary focus is to drive revenue, and manage risk within their branch and to continue to build a book of business. Job functions also include maint…
Engineering Technologist II - Wire Harness Quality Assurance
Description Position at Sumitomo Electric Wiring Systems, Inc. Job Title: Engineering Technologist II Primary Work Location — Warren, Michigan Basic Purpose: Engineering Technologist I…
Millwork Assembly -Team Lead
Job description Company: Versatile Wood Solutions is a leading Commercial Millwork and Contract Furniture company located in Nunica MI, seeking a skilled and experienced Millwork Assembly Team …
Housekeeper (Weekend Premium)- Holiday Inn Express Grandville
The Holiday Inn Express is a fast-paced, high-energy workplace, with endless opportunities for advancement. Come join the best team in the Hospitality Industry! * Shift: 1st-Part Time; Weeken…
Material Handler
Responsibilities for this Position Position Title: Material Handler Location: Sterling Heights, MI, United States Category: Manufacturing Operations Job Type: Full-Time Country: …
Occupational Therapy Assistant / COTA / OTA / PRN
Broad River Rehab is Growing!! Broad River Rehab has a GREAT, PRN opportunity for Certified Occupational Therapy Assistant (COTA). Occupational Therapy Assistant (COTA) - PRN Skilled Nursing Fa…