Job ID: 2216513
Location: ANAHEIM, CA, United States
Date Posted: Jan 13, 2023
Category: Information Technology
Subcategory: Database Admin
Shift: Day Job
Minimum Clearance Required: None
Clearance Level Must Be Able to Obtain: None
Potential for Remote Work: No Remote
Benefits: Click here
Join SAIC in supporting a team that is responsible for performing database administration in support of the Database Management Systems (DBMS) applications. This role will require someone to be onsite in Anaheim at least 3 days a week. The role may require someone to be onsite 5 days a week in the future.
The Database Administrator Lead reports directly to the Applications Service Delivery Manager and will support the City of Anaheim’s database requirements by providing application maintenance & operational support, ensure availability, drive continual service improvements to reduce cost and improve uptime and work with the application development team.
The Database Administrator will work cross functionally to resolve database and application issues, support applications support and development teams, and provide guidance and recommendations around database applications, operations and overall environment improvements.
Lead DBA providing leadership and guidance to team of DBAs.
Plan and coordinate team staff tasks and projects
Maintain databases across multiple platforms and computer environments.
Provide guidance and support to Application Developers
Assist with schema design, code review, SQL query tuning
Install, tune, implement and upgrade DBMS installations
Plan and deploy SQL and Oracle patches
Upgrade and improve application schema and database upgrades
Process work accurately and in a timely manner
Pay attention to detail at all times
Proactively and regularly make recommendations for system improvements
Collate, prepare and present statistical information for status reporting
Performs complex database administration assignments essential to the production and development of Database Management Systems (DBMS) applications.
Assignments, which are in direct support of software development and maintenance teams, include database analysis, security support, design, software use, performance monitoring and tuning, and general technical expertise.
Reviews and ensures integrity via standardized support tools. Ensures and monitors that assignments are performed in accordance with database administration guidelines, standards and procedures for applications development, implementation, testing, and migration.
Responds to complex customer-reported systems problems.
Evaluates and recommends use of software, guidelines, procedures, and development of project plans to lower level staff.
Provides DBMS expertise to other groups as requested. Provides work direction and guidance to team members and others
Regularly interacts with senior management or executive levels on matters concerning several functional areas, divisions, and/or customers. Requires the ability to change the thinking of, or gain acceptance of others in sensitive situations.
Bachelor’s degree in computer science or a related field
Five (5) years of experience with SQL coding
Design and implement a business processes into functional and efficient code (i.e. stored procedures)
Implement and manage data management best practices in accordance with City and SAIC policies and procedures
Five (5) years of experience in administering, managing, and tuning databases
Five (5) years of experience with Oracle and SQL Server.
Extensive knowledge of Oracle Real Application Cluster (RAC).
Good understanding of Recovery Manager and Data Guard.
Good understand of database design, modeling, implementation, troubleshooting, maintenance, and performance tuning.
Good knowledge of SQL Tuning with hands on SQL Trace and TKPROF.
Good understanding of data and schema standards and concepts
Covid Policy: SAIC does not require COVID-19 vaccinations or boosters. Customer site vaccination requirements must be followed when work is performed at a customer site.
SAIC® is a premier Fortune 500® technology integrator driving our nation's technology transformation. Our robust portfolio of offerings across the defense, space, civilian, and intelligence markets includes secure high-end solutions in engineering, digital, artificial intelligence, and mission solutions. Using our expertise and understanding of existing and emerging technologies, we integrate the best components from our own portfolio and our partner ecosystem to deliver innovative, effective, and efficient solutions that are critical to achieving our customers' missions.
We are approximately 26,000 strong; driven by mission, united by purpose, and inspired by opportunities. SAIC is an Equal Opportunity Employer, fostering a culture of diversity, equity, and inclusion, which is core to our values and important to attract and retain exceptional talent. Headquartered in Reston, Virginia, SAIC has annual revenues of approximately $7.4 billion. For more information, visit saic.com. For ongoing news, please visit our newsroom.