Responsibilities
Responsible for the day-to-day database operations in the CA Service Center.
Responsible for the training, staffing, and operational efficiency of the database operations team.
Responsible for the administrative/operational leadership of the database operations team within the program guidelines set by the Program Manager and DOS CA customer.
Monitors project to ensure work scope, schedule, and budget are well defined and maintained
Provides the coordination between resource managers/supervisors and ensures all necessary reviews and approvals are received
May conduct performance/project analyses during phase-down to benefit future/other projects/missions/programs
Works in a data warehouse environment that includes data design, database architecture, metadata and repository creation
Translates business needs into long-term architecture solutions
Defines, designs, and builds dimensional databases
Responsible for developing data warehousing blueprints, evaluating hardware and software platforms, and integrating systems
Recommends and develops needed modifications to the architecture plans and manages architecture programs to support the mission
Prepares reports and correspondence that articulate highly complex program findings or agency policies for dissemination to senior level leaders
Conducts unbiased assessment of industry architecture direction, emerging trends, best practices, automated tools, innovative approaches, and contribute, when appropriate, on architecture issues within the DOS.
Evaluates reusability of current data for additional analyses
Conducts data cleaning to rid the system of old, unused, or duplicate data
Reviews object and data models and the metadata repository to structure the data for better management and quicker access
Develop and document database architectures
Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements
Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements
Create and enforce database development standards
Demonstrate database technical functionality, such as performance, security and reliability
Design database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure
Design databases to support business applications, ensuring system scalability, security, performance and reliability
Develop data models for applications, metadata tables, views or related database structures
Develop load-balancing processes to eliminate down time for backup processes
Develop or maintain archived procedures, procedural codes, or queries for applications
Performs related duties as assigned
Qualifications
MINIMUM REQUIREMENTS
BA/BS in information Technology or related discipline or equivalent,
Possesses an Oracle Certified Professional (OCP) certification.
A minimum of five (5) years of experience in database administration supporting the migration to modernized databases and managing/leading a database staff for projects with a similar size, scope, and complexity to the requirements of the task.
Possesses a CompTIA Security+
Top Secret Clearance
PREFERRED EDUCATION AND EXPERIENCE
Possesses an ITIL Foundations Level Certification (or higher).
Demonstrated experience with projecting and planning for long-range requirements for database administration and design.
Demonstrated experience conducting quality control and auditing of databases including organization protection and security and documentation and reporting in an environment similar to the CA environment.
Demonstrated experience with database technologies, development methodologies, front-end/back-end database programming.
Work Environment
May require occasional travel between work centers or to client sites.
Some after-hours or on-call support may be necessary.
On-site work in a secure government or contractor facility.
Must be able to work in a high-security environment and comply with all relevant security protocols.
Sitting for long periods
Standing for long periods
Ambulate throughout an office
Ambulate between several buildings
Stoop, kneel, crouch, or crawl as required
Repeatedly lift and carry weight up to 30 pounds
Travel by land or air transportation 5 %
About Empower AI
All hiring and promotion decisions at Empower AI are based on merit to bring the best talent available to contribute to our firm’s overall success. It is the policy of Empower AI not to discriminate against any applicant for employment, or employee because of age, color, sex, disability, national origin, race, religion, or veteran status. Empower AI is a VEVRAA Federal Contractor.
If hired for this position, the base salary range would be within the range provided. The base salary range represents the anticipated low and high end of the salary range for this position. Actual salaries may vary based on various factors including but not limited to work location, skills, experience, gov con contractual requirements, and performance. The range listed is just one component of Empower AI's total compensation package for employees.
Pay Band Min
USD $121,490.00/Yr.
Pay Band Max
USD $188,040.00/Yr.