Career Opportunity

Senior Database Engineer - Department of Technology (1043)

Recruitment: REF52Z

Published: May 23, 2023

Apply using SmartRecruiters, the City and County of San Francisco's application portal Learn More

About:

This announcement has been updated to adjust the Company Description.

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!

Role description

Position:

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.

Essential Duties:

• 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 24x7 standby support on a rotational basis.

Job Type:

The Permanent Exempt - Full Time position is excluded by the Charter from the competitive civil service examination process and shall serve at the discretion of the appointment officer. The anticipated duration of this project position is thirty-six (36) months and will not result in an eligible list or permanent civil service hiring.

Nature of Work:

Incumbent must be willing to work a 40-hour week as determined by the department. 

Work Location:

Incumbent will conduct the majority of work at the Department of Technology, One South Van Ness Avenue, 2nd Floor. However, there may be situations where the incumbent will be required to work at other sites throughout the City of San Francisco as necessary. 

This position does not support fully remote work. Employees may be permitted to work a hybrid schedule with supervisor approval, after which they must work at least two days in the office every two weeks.

How to qualify

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).

Note:

1) Medical Testing: Prior to appointment, eligible candidates must successfully pass the TB testing process.

2) Security Clearances & Background Investigations: Positions in this classification may require that successful candidates who become eligible for appointment may be required to go through a background investigation to determine the candidate's suitability for employment in this classification.  Factors considered in the investigation may include employment history, use of illegal/controlled substances.  Reasons for rejection based on this investigation may include, but not limited to applicable convictions, repeated or serious violations of the law, inability to accept supervision, inability to follow rules and regulations, falsification of application materials and/or other relevant factors.  Failure to obtain and maintain security clearance may be basis for termination.

IMPORTANT: Applicants are REQUIRED to attach a resume and a statement of interest at the time of filing by using the "additional attachments" link contained within the application.

What else should I know?

Compensation: $67.0875 - $84.4000 (hourly) / $139,542 - $175,552 (annual)

How to Apply:

• Your application MUST include a resume.  To upload, please attach using the "additional attachments" function.
• Your application MUST include responses to the supplemental Questionnaire: https://forms.gle/ifV9RVgms31P5vuK7

You may contact Carol Wong via email at carol.x.wong@sfgov.org with questions regarding this opportunity.

Late or incomplete submissions will not be considered. Mailed, hand delivered or faxed documents/applications will not be accepted.

Helpful Information

• Information About The Hiring Process
• Conviction History
• Employee Benefits Overview  
• Equal Employment Opportunity 
• Disaster Service Worker
• ADA Accommodation
• Veterans Preference
• Right to Work
• Copies of Application Documents
• Diversity Statement

All your information will be kept confidential according to EEO guidelines.

CONDITION OF EMPLOYMENT:  All City and County of San Francisco employees are required to be fully vaccinated against COVID-19 as a condition of employment. Someone is fully vaccinated when 14 days have passed since they received the final dose of a two-shot vaccine or a dose of a one-shot vaccine. Any new hire must present proof of full vaccination status to be appointed. Any new hire who will be routinely assigned or occasionally enter High-Risk Settings, must provide proof of having received a COVID-19 booster vaccine by March 1, 2022, or once eligible.

The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition (associated with cancer, a history of cancer, or genetic characteristics), HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.