Senior Database Engineer
The Department of Technology database team is highly regarded across the City for its excellence in customer support and responsiveness. This team provides centralized database administration services supporting critical applications for City departments. City clients include the Controller Peoplesoft People and Pay, Financials, and BI applications, the Police department Crime Data Warehouse and Incident reporting system, 311 Customer Service Center applications, and the Department of Technology service areas such as Security, GIS, and Finance that depend on database platforms.
As part of this team, you will be responsible for all aspects of database administration from installation of the most current Oracle, SQL Server, and PostgreSQL technology to architecting and supporting high availability and disaster recovery architectures. We are looking for a highly skilled technician and problem solver who can work independently as well as partner and share knowledge with co-workers.
Responsibilities
- Participate in overall project planning, providing database tasks and milestones for project plans.
- Establish and maintain database standards for operational systems.
- Install, upgrade, and patch database software and related products.
- Participate in hardware capacity planning and configuration for database environments.
- Plan and implement database backup and recovery procedures and schedules based on application requirements.
- Monitor database environments and proactively address issues.
- Architect high availability and disaster recovery solutions for database environments.
- Analyze and resolve database-related issues in areas of performance, availability, and production operations as needed within established SLAs.
- Attend project meetings with Department of Technology and client department staff.
- Provide 24×7 standby support on a rotational basis.
Requirements
1. An associate degree in computer science or a closely related field from an accredited college or university OR its equivalent in terms of total course credits/units [i.e., at least sixty (60) semester or ninety (90) quarter credits/units with a minimum of twenty (20) semester or thirty (30) quarter credits/units in computer science or a closely-related field]; AND
2. Three (3) years of experience analyzing, installing, configuring, enhancing, and/or maintaining the components of Oracle database environments.
SUBSTITUTION: Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of two (2) years). One (1) year is equivalent to thirty (30) semester units/ forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in computer science or a closely related field.
Desirable Qualifications
- Experience with the Exadata Oracle Engineered system.
- Experience with Oracle 11g, 12c, and 19c database versions.
- Experience with the SQL Server database platform.
- Experience with the PostgreSQL open source database platform.
Special Requirements:
Criminal Justice Information Services (CJIS) Security Clearance is required. (See Security Clearances and Background Investigations below).
About SAN FRANCISCO DEPARTMENT OF TECHNOLOGY
Why Work for the Department of Technology (DT)? DT is the centralized technology services provider in the City and County of San Francisco (CCSF). We deliver technology infrastructure and services to approximately 33,000 employees! With an annual operating budget of over $140M and approximately 260 employees, DT provides a host of services that range from Public Safety radio and wiring and Network services to Enterprise Support and the Cloud.
Benefits of Working for CCSF: In addition to challenging and rewarding work, the City provides a generous suite of benefits to its employees.
- Job security, pension, and robust retirement options
- Competitive pay with consistent bi-yearly or yearly increases
- Hybrid Work with a minimum of 20% of time spent in our office in San Francisco, California for all IT related roles
- Generous paid time off, family leave, and more!
- Diverse work environment in a diverse city
- Union protections and representation
- Career development and growth — move between departments, learn on the job, or take subsidized/reimbursed classes!
PEOPLE-CENTERED SOLUTIONS — have a powerful, meaningful effect on the community each day with people at the heart of every solution!
CLOSING THE DIGITAL DIVIDE — bring the benefits of the internet to low-income and marginalized residents!
SHINE A LIGHT ON WHAT MATTERS — join an award-winning production team at SFGovTV to help residents watch legislators or learn more about what makes this City great!
DRIVE INNOVATION — deliver new, cutting-edge technology to residents and city partners to help San Francisco serve its residents!
