Database Support Manager (DSM)

OverviewEmpower AI is AI for government. Empower AI gives federal agency leaders the tools to elevate the potential of their workforce with a direct path for meaningful transformation. Headquartered in Reston, Va., Empower AI leverages three decades of experience solving complex challenges in Health, Defense, and Civilian missions. Our proven Empower AI Platform provides a practical, sustainable path for clients to achieve transformation that is true to who they are, what they do, how they work, with the resources they have. The result is a government workforce that is exponentially more creative and productive. For more information, visit www.Empower.ai.Empower AI is proud to be recognized as a 2024 Military Friendly Employer by Viqtory, the publisher of G.I. Jobs. This designation reflects the company's commitment to hiring and supporting active-duty and veteran employees.ResponsibilitiesOverview:This effort provides Operations and Maintenance (O&M) of mission-critical IT systems for the Department of State, Consular Affairs (CA), supporting 10,000 users across 230 overseas posts, 29 domestic passport agencies, and multiple data centers.The Database Support Manager (DSM) shall oversee the team responsible for the overall success of the globally dispersed databases. The DSM shall also be responsible for overseeing the performance of Tier II and Tier III support (as appropriate). This includes supporting Oracle (Version 11g or higher) and Microsoft SQL Server (Version 2008 R2 or higher) platforms and proactively monitoring databases to respond to incidents and alerts. The DSM shall be responsible for the monitoring and management of the database environment support for CA and for optimizing database performance, availability, and capacity. The DSM shall also automate manual maintenance, diagnostic health checks, validation, and reporting.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 maintainedProvides the coordination between resource managers/supervisors and ensures all necessary reviews and approvals are receivedMay conduct performance/project analyses during phase-down to benefit future/other projects/missionsWorks in a data warehouse environment that includes data design, database architecture, metadata and repository creationTranslates business needs into long-term architecture solutionsDefines, designs, and builds dimensional databasesResponsible for developing data warehousing blueprints, evaluating hardware and software platforms, and integrating systemsRecommends and develops needed modifications to the architecture plans and manages architecture programs to support the missionPrepares reports and correspondence that articulate highly complex program findings or agency policies for dissemination to senior level leadersConducts 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 analysesConducts data cleaning to rid the system of old, unused, or duplicate dataReviews object and data models and the metadata repository to structure the data for better management and quicker accessDevelop and document database architecturesDevelop database architectural strategies at the modeling, design and implementation stages to address business or industry requirementsCollaborate with system architects, software architects, design analysts, and others to understand business or industry requirementsCreate and enforce database development standardsDemonstrate database technical functionality, such as performance, security and reliabilityDesign 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 structureDesign databases to support business applications, ensuring system scalability, security, performance and reliabilityDevelop data models for applications, metadata tables, views or related database structuresDevelop load-balancing processes to eliminate down time for backup processesDevelop or maintain archived procedures, procedural codes, or queries for applicationsPerforms related duties as assignedMINIMUM REQUIREMENTSBA/BS in information Technology or related discipline or equivalentPossesses 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+PREFERRED EDUCATION AND EXPERIENCEPossesses 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 EnvironmentMay 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 periodsStanding for long periodsAmbulate throughout an officeAmbulate between several buildingsStoop, kneel, crouch, or crawl as requiredRepeatedly lift and carry weight up to 30 poundsTravel by land or air transportation 5 %About Empower AIAll 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.J-18808-Ljbffr