Career Opportunity

Senior Database Administration and Systems Engineer- Department of Technology (1043)

Recruitment: RTF0129482-01138896

Published: February 15, 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.

IMPORTANT: Your application MUST include responses to the supplemental questionnaire found here: https://forms.gle/uriZ2z4GYrqjouBJ9

Applicants must complete the supplemental questionnaire prior to starting the online application process. The application will not be reviewed without a completed supplemental questionnaire. 

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

The Department of Technology JUSTIS team is highly regarded across the City for its excellence in customer support and responsiveness. JUSTIS is a program inside the City & County of San Francisco (CCSF) to modernize CCSF's Criminal Justice Systems.  You will be working alongside principal and senior engineers and analysts with deep knowledge of criminal justice and how it functions in San Francisco to implement requirements of our criminal justice agencies. We are looking for a talented, driven, and experienced Oracle Database Administrator/Systems Engineer with proven skills in database administration and systems engineering. Backed by a Gartner five-year Roadmap, the project involved creating a new application and data hub where all criminal justice agencies go to store and retrieve data. These agencies have relied on a centralized mainframe system for many years to get their operational reports. Agencies have transitioned to the JUSTIS data hub where transactions, queries, and reports have been created that serve their needs. 

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 architecture, as well as a systems engineer.  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:

Under the direction of Cyber Security Defense Operations Manager, you will

• Participate in overall project planning, providing database tasks and milestones for project plans.
• Create, update and maintain databases and other database objects, i.e., tables, tablespaces, user permissions, views.
• Import, convert, and standardize data tables from various sources.
• Establish and maintain database standards for development, test, and operational systems.
• Install, upgrade, and patch database software and related products, i.e., Oracle database/container and pluggable database, Oracle application server, Oracle SOA Suite, Oracle BPEL, Oracle http server, WebLogic server.
• Participate in hardware capacity planning and configuration for database environments.
• Plan and implement database backup and recovery procedures and schedules based on application requirements.
• Plan, implement, maintain and coordinate upgrades/updates/fixes for core operating systems and their related components, without negative impact to the overall availability and reliability of the enterprise systems/networks.
• Installation and configuration of application credential, security certificate on systems and application servers.
• Develop scripts to 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.
• Work with the infrastructure team to provision new Windows/Linux workstations and serves.
• Work with the application team to install, setup and configuration Oracle SOA suite, configure WebLogic
• Provide 24-hour standby and/or on-call support on a rotation basis to ensure rapid recovery from software or hardware problems for mission-critical systems and networks.
• Monitor daily systems performance and proactively address issues.
• Attend project meetings with Department of Technology and client department staff.

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. Twenty-four hour on-call support and occasional weekend work is required. 

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 is not supporting 100% working remotely that employee needs to work two days in the office every two weeks.  

How to qualify

Education:

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

Experience:

Three (3) years of experience analyzing, installing, configuring, enhancing, and/or maintaining the components of System and Server 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:

• Bachelor's/Master's degree from an accredited college or university, preferably in management information system, information technology, computer science, business administration, or a closely related field
• Five (5) years of experience in database administration/systems engineering, including analyzing, installing, configuring, enhancing, and/or maintaining the components of Oracle databases.
• Strong understanding of the Oracle and Microsoft technology stacks (container database, pluggable database, SQL.net, database replication, database backup, SQL Server, Integration Services, Analysis Services, Reporting Services, etc.)
• Experience with Oracle 10g, 11g, 12c, 18c, and 19c database versions.
• Experience with the SQL Server database platform, Microsoft Windows Servers, Linux.  Scripting to extract database and system health and performance data.
• Experience with criminal justice data and agencies a plus

Note:

1)  Security Clearances & Background Investigations: Criminal Justice Information Services (CJIS) Security Clearance may be required. 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.

Verification: Applicants may be required to submit verification of qualifying education and experience at any point in the application and/or departmental selection process. Written verification (proof) of qualifying experience must verify that the applicant meets the minimum qualifications stated on the announcement. Written verification must be submitted on employer’s official letterhead, specifying name of employee, dates of employment, types of employment (part-time/full-time), job title(s), description of duties performed, and the verification must be signed by the employer. City employees will receive credit for the duties of the class to which they are appointed. Credit for experience obtained outside of the employee’s class will be allowed only if recorded in accordance with the provisions of the Civil Service Commission Rules. Experience claimed in self-employment must be supported by documents verifying income, earnings, business license and experience comparable to the minimum qualifications of the position. Copies of income tax papers or other documents listing occupations and total earnings must be submitted. If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at http://sfdhr.org/index.aspx?page=456.

Note: Falsifying one’s education, training, or work experience or attempted deception on the application may result in disqualification for this and future job opportunities with the City and County of San Francisco. 

What else should I know?

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

How to Apply:

• In addition to submitting your application, you MUST submit this supplemental questionnaire: https://forms.gle/uriZ2z4GYrqjouBJ9
• Your application MUST include a resume.  To upload, please attach using the "additional attachments" function.

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.

Right to Work:

All persons entering the City and County of San Francisco workforce are required to provide verification of authorization to work in the United States. 

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.