Cal State University (CSU) San Francisco
1600 Holloway Avenue, San Francisco, CA 94132, USA
Working Title Housing and Business Applications Analyst SF State University San Francisco State is an Equal Opportunity Employer and does not discriminate against persons on the basis of race, religion, color, ancestry, age, disability, genetic information, gender, gender identity, gender expression, marital status, medical condition, National origin, sex, sexual orientation, covered veteran status, or any other protected status. Reasonable accommodations will be provided for qualified applicants with disabilities who self-disclose by contacting the Senior Human Resources Manager. Applicants may visit titleix.sfsu.edu for more information on SF State's policy prohibiting discrimination, and how to file an online report using the procedures under Executive Order 1096 Revised. Inquiries can be directed to the campus Title IX Coordinator and Discrimination, Harassment, and Retaliation Administrator by calling (415) 338-2032 or emailing vpsaem@sfsu.edu. San Francisco State is a 100% Smoke/Vapor-Free Campus. Smoking or Vaping of any tobacco/plant-based substance is not permitted on any University properties. The person holding this position may be considered a "mandated reporter" under the California Child Abuse and Neglect Reporting Act and is required to comply with the requirements set forth in CSU Executive Order 1083 as a condition of employment. This position may be a "designated position" in the California State University's Conflict of Interest Code. The successful candidate accepting this position may be required to file Conflict of Interest forms subject to the regulations of the Fair Political Practices Commission. Department Information Technology Services Appointment Type This is a one-year probationary position. Time Base Full-Time Work Schedule Monday through Friday; from 8:00am to 5:00pm Anticipated Hiring Range $6,667 - $7,084 Per Month ($80,004.00 - $85,008.00 Annually) Salary is commensurate with experience. Position Summary The employee, reporting to the Director of Web and Mobile Applications, serves as a business applications analyst and software developer for business applications maintained by the Web and Mobile Applications unit in support of student housing, dining, and conference services. The housing and business applications analyst performs systems analysis, configuration, development, programming, documentation and support for business applications including the resident and property management platform, campus commerce platform, and custom integrations into other SF State applications. Position Information Provide analysis and development of university resident and property management platform, campus commerce platform, and integrations into other campus systems Engage with campus constituents to identify and document software/system purpose, work flow issues, output needs, and to determine overall functional and technical system requirements and specifications Analyze requirements and, in collaboration with information technology peers, design appropriate solutions Work with project leadership, constituents, and application programmers to estimate and document project resource requirements Develop alternative solutions and conduct feasibility studies Evaluate the procurement of third party software and troubleshoot new software installations Design, test, document, and implement SQL queries on Oracle, MSSQL, MySQL, or similar Maintain custom application integration solutions using scalable and maintainable approaches in collaboration with other technical experts Write software and scripts to meet user specifications Work with user community to understand data access and integration needs Develop test plans and work with users to test and debug programs Construct flow charts, data flow diagrams, and similar documentation Knowledge of system security requirements Ability to use project management techniques and tools to track and report on project status and mitigate identified risks Provide end-user support and reporting for all supported applications and integrations Assist operations in problem determination and resolution Triage, troubleshoot, and resolve application issues, understanding and supporting processes and applications across multiple business areas Review and manage incoming support tickets in a timely manner Support multi-vendor and multi-protocol middleware technologies for databases and applications Write documentation to provide user support for new or modified programs and production/operation procedures At all times: Demonstrate behaviors that are in line with the User-Friendly Principles (P530C) and Principles of Conduct for a Multi-Cultural University (P30D) Demonstrate safe work practices for oneself, others, and the office environment. Minimum Qualifications To enter this classification, a basic foundation of knowledge and skills in applications programming and systems analysis and related programming support functions is a prerequisite. This foundation would normally be obtained through a bachelor’s degree, preferably in computer science or business, or equivalent training and applied experience. Foundation knowledge and skills for the Analyst/Programmer, depending on the position assignment, may include working knowledge of a specific industry standard applications programming language and knowledge of standard systems analysis techniques. The career level is broad and includes intermediate through senior level positions. Incumbents at this level work relatively independently and possess the experience to be fully proficient in performing most or all of the work assignments defined for their position. Typically, incumbents have acquired the requisite skills and knowledge through a combination of education, training, and progressive work experience to be able to demonstrate competence in independently applying technical judgment to standard and nonstandard applications and systems, solving a wide range of problems and developing practicable and thorough solutions, and using effective communication and listening skills. Preferred Qualifications Education/Work Experience Bachelor’s degree in computer science, information systems, information technology, or related field; equivalent experience can be substituted for education on a year-for-year basis. A minimum of 3 years of experience in the following: a database structured query language, a high-level programming language, project management, requirements analysis, user support. Knowledge Understanding of business and technical workflows; basic networking and firewall functions. Skills/Abilities Work independently with consultation with team lead as required; perform multiple tasks concurrently and respond to emergency situations effectively Strong oral and written communication skills with professional presentation skills Strong computer science fundamentals; able to create scalable and maintainable solutions Provide technical end-user support to users with varying levels of expertise and knowledge Recognize and resolve application related problems through effective troubleshooting and collaboration with other technical experts Experience collecting user requirements, performing systems analysis, designing an appropriate solution, and estimating time and resources required to complete Experience with relational database analysis and design and the use of structured query languages like Oracle SQL Experience designing and building application integrations with scripting languages like PowerShell, Batch, Visual Basic, Java, Unix shell Experience with StarRez or OneSite resident and property management systems Experience with Agile methodology Experience with higher education institutions Pre-Employment Requirements This position requires the successful completion of a background check. The employee Eligibility to Work The employee maybe required to sit in an open office environment with other project team members. This is an exempt position and is not subject or eligible for overtime or compensatory time off. The employee may be required to work outside of their regular work schedule to perform maintenance, deployment, or other support activities. The employee will be required to be available by cell phone and may be called after work hours to respond to critical service outages. Benefits Threaded through our Total Compensation package is a commitment to Bridging Life's Transitions. SF State is committed to providing our employees with a comprehensive program that rewards efforts that are appreciated by your colleagues, students and the customers we serve. We offer a competitive compensation package that includes Medical, Dental, Vision, Pension, 401k, Healthcare Savings Account, Life Insurance, Disability Insurance, Vacation and Sick Leave as well as State Holidays and a dynamic Fee Waiver program, all geared towards the University's commitment to attract, motivate and retain our employee. CSUEU Position (For CSUEU Positions Only) Eligible and qualified on-campus applicants, currently in bargaining units 2, 5, 7, and 9 are given hiring preference. Additional Information SF STATE IS NOT A SPONSORING AGENCY FOR STAFF OR MANAGEMENT POSITIONS. (i.e. H1-B VISAS). Thank you for your interest in employment with California State University (CSU). CSU is a state entity whose business operations reside within the State of California. Because of this, CSU prohibits hiring employees to perform CSU-related work outside of California with very limited exception. While this position may be eligible for occasional telework, all work is expected to be performed in the state of California, and this position is assigned to on-campus operations. CSU strongly encourages faculty, staff, and students who are accessing campus facilities to be immunized against COVID-19 or declare a medical or religious exemption from doing so. Any candidates advanced in a currently open search process are encouraged to comply with this requirement. The systemwide policy can be found at https://calstate.policystat.com/policy/9779821/latest/ and questions may be sent to hr@campus.edu. The Human Resources office is open Mondays through Fridays from 8 a.m. to 5 p.m., and can be reached at (415) 338-1872. Please note that this position, position requirements, application deadline and/or any other component of this position is subject to change or cancellation at any time. Advertised: Nov 21 2023 Pacific Standard Time Applications close: Closing Date/Time:
Working Title Housing and Business Applications Analyst SF State University San Francisco State is an Equal Opportunity Employer and does not discriminate against persons on the basis of race, religion, color, ancestry, age, disability, genetic information, gender, gender identity, gender expression, marital status, medical condition, National origin, sex, sexual orientation, covered veteran status, or any other protected status. Reasonable accommodations will be provided for qualified applicants with disabilities who self-disclose by contacting the Senior Human Resources Manager. Applicants may visit titleix.sfsu.edu for more information on SF State's policy prohibiting discrimination, and how to file an online report using the procedures under Executive Order 1096 Revised. Inquiries can be directed to the campus Title IX Coordinator and Discrimination, Harassment, and Retaliation Administrator by calling (415) 338-2032 or emailing vpsaem@sfsu.edu. San Francisco State is a 100% Smoke/Vapor-Free Campus. Smoking or Vaping of any tobacco/plant-based substance is not permitted on any University properties. The person holding this position may be considered a "mandated reporter" under the California Child Abuse and Neglect Reporting Act and is required to comply with the requirements set forth in CSU Executive Order 1083 as a condition of employment. This position may be a "designated position" in the California State University's Conflict of Interest Code. The successful candidate accepting this position may be required to file Conflict of Interest forms subject to the regulations of the Fair Political Practices Commission. Department Information Technology Services Appointment Type This is a one-year probationary position. Time Base Full-Time Work Schedule Monday through Friday; from 8:00am to 5:00pm Anticipated Hiring Range $6,667 - $7,084 Per Month ($80,004.00 - $85,008.00 Annually) Salary is commensurate with experience. Position Summary The employee, reporting to the Director of Web and Mobile Applications, serves as a business applications analyst and software developer for business applications maintained by the Web and Mobile Applications unit in support of student housing, dining, and conference services. The housing and business applications analyst performs systems analysis, configuration, development, programming, documentation and support for business applications including the resident and property management platform, campus commerce platform, and custom integrations into other SF State applications. Position Information Provide analysis and development of university resident and property management platform, campus commerce platform, and integrations into other campus systems Engage with campus constituents to identify and document software/system purpose, work flow issues, output needs, and to determine overall functional and technical system requirements and specifications Analyze requirements and, in collaboration with information technology peers, design appropriate solutions Work with project leadership, constituents, and application programmers to estimate and document project resource requirements Develop alternative solutions and conduct feasibility studies Evaluate the procurement of third party software and troubleshoot new software installations Design, test, document, and implement SQL queries on Oracle, MSSQL, MySQL, or similar Maintain custom application integration solutions using scalable and maintainable approaches in collaboration with other technical experts Write software and scripts to meet user specifications Work with user community to understand data access and integration needs Develop test plans and work with users to test and debug programs Construct flow charts, data flow diagrams, and similar documentation Knowledge of system security requirements Ability to use project management techniques and tools to track and report on project status and mitigate identified risks Provide end-user support and reporting for all supported applications and integrations Assist operations in problem determination and resolution Triage, troubleshoot, and resolve application issues, understanding and supporting processes and applications across multiple business areas Review and manage incoming support tickets in a timely manner Support multi-vendor and multi-protocol middleware technologies for databases and applications Write documentation to provide user support for new or modified programs and production/operation procedures At all times: Demonstrate behaviors that are in line with the User-Friendly Principles (P530C) and Principles of Conduct for a Multi-Cultural University (P30D) Demonstrate safe work practices for oneself, others, and the office environment. Minimum Qualifications To enter this classification, a basic foundation of knowledge and skills in applications programming and systems analysis and related programming support functions is a prerequisite. This foundation would normally be obtained through a bachelor’s degree, preferably in computer science or business, or equivalent training and applied experience. Foundation knowledge and skills for the Analyst/Programmer, depending on the position assignment, may include working knowledge of a specific industry standard applications programming language and knowledge of standard systems analysis techniques. The career level is broad and includes intermediate through senior level positions. Incumbents at this level work relatively independently and possess the experience to be fully proficient in performing most or all of the work assignments defined for their position. Typically, incumbents have acquired the requisite skills and knowledge through a combination of education, training, and progressive work experience to be able to demonstrate competence in independently applying technical judgment to standard and nonstandard applications and systems, solving a wide range of problems and developing practicable and thorough solutions, and using effective communication and listening skills. Preferred Qualifications Education/Work Experience Bachelor’s degree in computer science, information systems, information technology, or related field; equivalent experience can be substituted for education on a year-for-year basis. A minimum of 3 years of experience in the following: a database structured query language, a high-level programming language, project management, requirements analysis, user support. Knowledge Understanding of business and technical workflows; basic networking and firewall functions. Skills/Abilities Work independently with consultation with team lead as required; perform multiple tasks concurrently and respond to emergency situations effectively Strong oral and written communication skills with professional presentation skills Strong computer science fundamentals; able to create scalable and maintainable solutions Provide technical end-user support to users with varying levels of expertise and knowledge Recognize and resolve application related problems through effective troubleshooting and collaboration with other technical experts Experience collecting user requirements, performing systems analysis, designing an appropriate solution, and estimating time and resources required to complete Experience with relational database analysis and design and the use of structured query languages like Oracle SQL Experience designing and building application integrations with scripting languages like PowerShell, Batch, Visual Basic, Java, Unix shell Experience with StarRez or OneSite resident and property management systems Experience with Agile methodology Experience with higher education institutions Pre-Employment Requirements This position requires the successful completion of a background check. The employee Eligibility to Work The employee maybe required to sit in an open office environment with other project team members. This is an exempt position and is not subject or eligible for overtime or compensatory time off. The employee may be required to work outside of their regular work schedule to perform maintenance, deployment, or other support activities. The employee will be required to be available by cell phone and may be called after work hours to respond to critical service outages. Benefits Threaded through our Total Compensation package is a commitment to Bridging Life's Transitions. SF State is committed to providing our employees with a comprehensive program that rewards efforts that are appreciated by your colleagues, students and the customers we serve. We offer a competitive compensation package that includes Medical, Dental, Vision, Pension, 401k, Healthcare Savings Account, Life Insurance, Disability Insurance, Vacation and Sick Leave as well as State Holidays and a dynamic Fee Waiver program, all geared towards the University's commitment to attract, motivate and retain our employee. CSUEU Position (For CSUEU Positions Only) Eligible and qualified on-campus applicants, currently in bargaining units 2, 5, 7, and 9 are given hiring preference. Additional Information SF STATE IS NOT A SPONSORING AGENCY FOR STAFF OR MANAGEMENT POSITIONS. (i.e. H1-B VISAS). Thank you for your interest in employment with California State University (CSU). CSU is a state entity whose business operations reside within the State of California. Because of this, CSU prohibits hiring employees to perform CSU-related work outside of California with very limited exception. While this position may be eligible for occasional telework, all work is expected to be performed in the state of California, and this position is assigned to on-campus operations. CSU strongly encourages faculty, staff, and students who are accessing campus facilities to be immunized against COVID-19 or declare a medical or religious exemption from doing so. Any candidates advanced in a currently open search process are encouraged to comply with this requirement. The systemwide policy can be found at https://calstate.policystat.com/policy/9779821/latest/ and questions may be sent to hr@campus.edu. The Human Resources office is open Mondays through Fridays from 8 a.m. to 5 p.m., and can be reached at (415) 338-1872. Please note that this position, position requirements, application deadline and/or any other component of this position is subject to change or cancellation at any time. Advertised: Nov 21 2023 Pacific Standard Time Applications close: Closing Date/Time:
CLARK COUNTY, NV
Clark County - Las Vegas, Nevada, United States
ABOUT THE POSITION The Clark County Information Technology Department is seeking qualified candidates to apply for the Senior Programmer Analyst (Full-Stack Developer) position. This position provides project and program leadership to professional and technical staff; performs applications systems design, modification, and programming of a routine to complex nature in support of County administrative and business services for multiple computer platform applications. This position Full-Stack web developer requires a strong proficiency in .NET, ASP.NET MVC, C# programing language, understanding database applications, such as SQL Server, Oracle, Informix, client-side technology including languages such as HTML, CSS, JavaScript, Bootstrap, experience with cross-platform mobile app development using Xamarin, MAUI, or other cross-platform development frameworks. Other Senior Programmer Analyst positions may be open that requires proficiencies in other technologies like JAVA, GIS, Python, SOAP Web Services, RESTful Services, etc. Applications received by July 7, 2023 and candidates meeting minimum requirements will receive notification the week of July 10th. Applications received after July 7, 2023 will be periodically screened for minimum qualifications and notification dates will vary. This examination will establish an Open Competitive Eligibility list to fill current and/or future vacancies that may occur within the next six (6) months or may be extended as needed by Human Resources. Human Resources reserves the right to call only the most qualified applicants to the selection process. MINIMUM REQUIREMENTS Education and Experience: Bachelor's Degree in Computer Science, Management Information Systems, or a related field AND four (4) years of full-time professional level experience in systems analysis and programming in a large information technology environment. Professional level experience that has provided the skills and knowledge necessary to perform all job functions at this level may be substituted for the education on a year-for-year basis to a maximum of two (2) years. Qualifying education and experience must be clearly documented in the “Education” and “Work Experience” sections of the application. Do not substitute a resume for your application or write "see attached resume" on your application. Working Conditions: Work extended shifts or be called back in emergency situations. Licensing and Certification: Specified positions may require possession of a valid Nevada Class C driver's license at time of appointment. Background Investigation: Employment is contingent upon successful completion of a background investigation. Periodically after employment background investigations may be conducted. Pre-Employment Drug Testing: Employment is contingent upon the results of a pre-employment drug examination. EXAMPLES OF DUTIES Provides lead direction, training and work review to a programming project team; organized and assigns work, sets priorities, and follows-up and controls project status to ensure coordination and completion of assigned work. Provides input into selection, evaluation, disciplinary and other personnel matters. Gathers and analyzes information regarding customer systems and requirements and develops or modifies automated systems to fulfill these needs. Conducts feasibility studies and develops system, time, equipment and cost requirements. Using computer generated techniques, simulates hardware and software problems, tests and evaluates alternative solutions, and recommends and implements appropriate applications design. Develops program logic and processing steps; codes programs in varied languages. Plans and develops test data to validate new or modified programs; designs input and output forms and documents. Troubleshoots hardware and software problems, as needed, for customers, other agencies and information systems personnel. Writes program documentation and customer procedures and instructions and assists user departments and staff in implementing new or modified programs and applications; tracks and evaluates project and systems progress. Writes utility programs to support and validate adopted systems and programs. Confers with customer department staff regarding assigned functional program areas. Maintains records and prepares periodic and special reports of work performed. Maintains current knowledge of technology and new computer customer applications. Contributes to the efficiency and effectiveness of the unit's service to its customers by offering suggestions and directing or participating as an active member of a work team. Uses standard office equipment in the course of the work; may drive a personal or County motor vehicle or be able to arrange for appropriate transportation in order to travel between various job sites depending upon departments and/or projects assigned. PHYSICAL DEMANDS Mobility to work in a typical office setting and use standard office equipment, stamina to remain seated and maintain concentration for an extended period of time, vision to read printed materials and a computer screen, and hearing and speech to communicate in person or over the telephone. Accommodation may be made for some of these physical demands for otherwise qualified individuals who require and request such accommodation. Come Make a Difference and Join the Clark County Family where we offer a comprehensive benefits package that includes: Flexible Schedules including 4/10 options More Money in Your Pocket 100% Employer Paid Defined Benefit Retirement No Social Security Deduction No State Income Taxes Two Employer Sponsored Health Plans Offered - Choice of PPO or EPO (hybrid of HMO) Medical - Employer pays 90% of premium Pharmacy Benefits (30, 90-day retail or mail order fills) 24/7 Telephone Advice Nurse - no employee cost Teledoc, Doctoroo, and Dispatch Health Retiree insurance - eligible after 5 years of service Dental Vision Life Insurance - Employer Paid AD&D - Employer Paid Long Term Disability - Employer Paid Generous Leave Accruals that include: 13Paid Holidays includinga Floating Birthday Holiday Paid Vacation Leave Paid Sick Leave Holiday Leave Other leave options Catastrophic Leave Parental Leave - Up to 90 days Wide Variety of Voluntary Benefits that include Guardian - Accident, Cancer, Critical Illness, Hospital Indemnity, and Short-Term Disability Insurance. Trustmark - Permanent Life Insurance benefits and long-term care. Sunlife Financial - Basic and Voluntary Life Insurance, AD&D, and long-term disability insurance TASC - Flexible Spending Account - FSA & Dependent Day Care Debit Card Available Morgan Stanley - Deferred Compensation Plan Employee Assistance Program Onsite Fitness Center - $12/month*Benefits vary and are subject to change depending on assignment, hiring organization and bargaining unit. Closing Date/Time: Continuous
ABOUT THE POSITION The Clark County Information Technology Department is seeking qualified candidates to apply for the Senior Programmer Analyst (Full-Stack Developer) position. This position provides project and program leadership to professional and technical staff; performs applications systems design, modification, and programming of a routine to complex nature in support of County administrative and business services for multiple computer platform applications. This position Full-Stack web developer requires a strong proficiency in .NET, ASP.NET MVC, C# programing language, understanding database applications, such as SQL Server, Oracle, Informix, client-side technology including languages such as HTML, CSS, JavaScript, Bootstrap, experience with cross-platform mobile app development using Xamarin, MAUI, or other cross-platform development frameworks. Other Senior Programmer Analyst positions may be open that requires proficiencies in other technologies like JAVA, GIS, Python, SOAP Web Services, RESTful Services, etc. Applications received by July 7, 2023 and candidates meeting minimum requirements will receive notification the week of July 10th. Applications received after July 7, 2023 will be periodically screened for minimum qualifications and notification dates will vary. This examination will establish an Open Competitive Eligibility list to fill current and/or future vacancies that may occur within the next six (6) months or may be extended as needed by Human Resources. Human Resources reserves the right to call only the most qualified applicants to the selection process. MINIMUM REQUIREMENTS Education and Experience: Bachelor's Degree in Computer Science, Management Information Systems, or a related field AND four (4) years of full-time professional level experience in systems analysis and programming in a large information technology environment. Professional level experience that has provided the skills and knowledge necessary to perform all job functions at this level may be substituted for the education on a year-for-year basis to a maximum of two (2) years. Qualifying education and experience must be clearly documented in the “Education” and “Work Experience” sections of the application. Do not substitute a resume for your application or write "see attached resume" on your application. Working Conditions: Work extended shifts or be called back in emergency situations. Licensing and Certification: Specified positions may require possession of a valid Nevada Class C driver's license at time of appointment. Background Investigation: Employment is contingent upon successful completion of a background investigation. Periodically after employment background investigations may be conducted. Pre-Employment Drug Testing: Employment is contingent upon the results of a pre-employment drug examination. EXAMPLES OF DUTIES Provides lead direction, training and work review to a programming project team; organized and assigns work, sets priorities, and follows-up and controls project status to ensure coordination and completion of assigned work. Provides input into selection, evaluation, disciplinary and other personnel matters. Gathers and analyzes information regarding customer systems and requirements and develops or modifies automated systems to fulfill these needs. Conducts feasibility studies and develops system, time, equipment and cost requirements. Using computer generated techniques, simulates hardware and software problems, tests and evaluates alternative solutions, and recommends and implements appropriate applications design. Develops program logic and processing steps; codes programs in varied languages. Plans and develops test data to validate new or modified programs; designs input and output forms and documents. Troubleshoots hardware and software problems, as needed, for customers, other agencies and information systems personnel. Writes program documentation and customer procedures and instructions and assists user departments and staff in implementing new or modified programs and applications; tracks and evaluates project and systems progress. Writes utility programs to support and validate adopted systems and programs. Confers with customer department staff regarding assigned functional program areas. Maintains records and prepares periodic and special reports of work performed. Maintains current knowledge of technology and new computer customer applications. Contributes to the efficiency and effectiveness of the unit's service to its customers by offering suggestions and directing or participating as an active member of a work team. Uses standard office equipment in the course of the work; may drive a personal or County motor vehicle or be able to arrange for appropriate transportation in order to travel between various job sites depending upon departments and/or projects assigned. PHYSICAL DEMANDS Mobility to work in a typical office setting and use standard office equipment, stamina to remain seated and maintain concentration for an extended period of time, vision to read printed materials and a computer screen, and hearing and speech to communicate in person or over the telephone. Accommodation may be made for some of these physical demands for otherwise qualified individuals who require and request such accommodation. Come Make a Difference and Join the Clark County Family where we offer a comprehensive benefits package that includes: Flexible Schedules including 4/10 options More Money in Your Pocket 100% Employer Paid Defined Benefit Retirement No Social Security Deduction No State Income Taxes Two Employer Sponsored Health Plans Offered - Choice of PPO or EPO (hybrid of HMO) Medical - Employer pays 90% of premium Pharmacy Benefits (30, 90-day retail or mail order fills) 24/7 Telephone Advice Nurse - no employee cost Teledoc, Doctoroo, and Dispatch Health Retiree insurance - eligible after 5 years of service Dental Vision Life Insurance - Employer Paid AD&D - Employer Paid Long Term Disability - Employer Paid Generous Leave Accruals that include: 13Paid Holidays includinga Floating Birthday Holiday Paid Vacation Leave Paid Sick Leave Holiday Leave Other leave options Catastrophic Leave Parental Leave - Up to 90 days Wide Variety of Voluntary Benefits that include Guardian - Accident, Cancer, Critical Illness, Hospital Indemnity, and Short-Term Disability Insurance. Trustmark - Permanent Life Insurance benefits and long-term care. Sunlife Financial - Basic and Voluntary Life Insurance, AD&D, and long-term disability insurance TASC - Flexible Spending Account - FSA & Dependent Day Care Debit Card Available Morgan Stanley - Deferred Compensation Plan Employee Assistance Program Onsite Fitness Center - $12/month*Benefits vary and are subject to change depending on assignment, hiring organization and bargaining unit. Closing Date/Time: Continuous
Cal State University (CSU) East Bay
25800 Carlos Bee Boulevard, Hayward, CA 94542, USA
Salary and Benefits PLEASE NOTE: The starting salary placement depends on qualifications and experience and is anticipated to be in the range of $7,500.00 per month to $9,584.00 per month. Cal State East Bay offers a broad range of benefits that includes medical, dental, vision, retirement (CalPERS), 401k, 457, 403(b), dependent and health care reimbursement accounts, life insurance, vacation and sick, 14 paid holidays, one personal holiday and tuition fee waiver. For more information on the benefits program, please visit our benefits website. The CSU Total Compensation Calculator demonstrates the significance of our benefits package. This position may be eligible to participate in the Cal State East Bay hybrid telecommute program subject to management approval. Classification Analyst/Programmer - Expert About Cal State East Bay Cal State East Bay's beautiful main campus is located in the Hayward hills with panoramic views of the San Francisco Bay shoreline. Situated above the city of Hayward, the campus offers an ideal setting for teaching and learning and yet easy access to the many cities along the bay. The University has a satellite campus in Concord, a professional development center in Oakland and a significant presence online. Founded in 1957, Cal State East Bay is one of 23 universities of the California State University system (CSU). Cal State East Bay is recognized as a regionally engaged and globally oriented university with a strong commitment to academic innovation, student success, engaged and service learning, diversity, and sustainability. About the Position This is a full-time, temporary position through December 31, 2024 with the possibility of re-appointment. Cal State East Bay’s enterprise-wide CRM (Customer Relationship Management) implementation program, Compass, is scaling at lightning speed! We are looking to expand our CRM development team in central ITS. This is a great opportunity for a Salesforce developer who is highly motivated to grow and transform Higher Education. We are seeking a candidate who is committed to excellence in customer service, technical expertise and development. Join our team to deliver high-impact and meaningful projects focused on student success! This is a senior level position responsible for designing, developing, and supporting innovative Salesforce (CRM) solutions to support faculty, staff and student success initiatives. This position works with project manager(s), solution partners, other technical team members and third-party applications/managed packages to expand the depth and breadth of the University’s CRM ecosystem. Responsibilities Work on multiple projects from requirements gathering through solution design, build, testing, and deployment. Perform the build activities to deliver a solution from the design stage, to prototype, to a functional application. Develop applications using the Salesforce platform (Apex classes/triggers, Web Services API, be proficient in visual Flows), Angular JS, related web technologies (CSS3, HTML5, Ajax, JavaScript) and other enterprise programming languages such as Java. Implement new enhancements including creation of custom objects, workflows, email alerts and templates and campaigns. Develop, integrate, and maintain Salesforce with third party solutions or web services, including but not limited to PeopleSoft, Canvas, Tableau, and other higher education applications. Solve complex business problems. Participate in design and code reviews to ensure development quality. Execute unit tests and write Apex test classes for code coverage. Use development tools such as Eclipse IDE (for source code editor, debugging and deployment) and GIT (for source code and version control). Deploy metadata (configuration and code) to different environments via tools such as Ant and Flosum. Use tools such as Data Loader for data export, backup and migration between environments. Design user interfaces and create corresponding data relationship diagram(s) using LucidChart or similar tools to represent the data models and illustrate relationships between database elements. Create process flow diagrams to represent the logic and algorithms used to implement the business rules and requirements. Create and maintain user roles, security, permissions, profiles, workflow rules, etc. Understand the data architecture of SaaS products (i.e. Salesforce, Tableau), iPaaS products (i.e. Dell Boomi), and third-party open-source (i.e. MySQL) and commercial (i.e. PeopleSoft) software applications, and other SaaS products (i.e. FormAssembly) sources that integrate Salesforce CRM. Stay current with latest releases, maintenance packs/patches, and upgrades. Perform problem diagnosis and resolution. Use advanced troubleshooting and analysis to resolve problems at the root cause. Apply technical skills and creative problem-solving techniques to ensure customer issues are resolved in a timely manner. Integrate security into Software Development Life Cycle (SDLC) and provide technical documentation, work methodologies, best practices and repeatable processes. Ensure CSU Accessible Technology Initiative (ATI) standards are incorporated in all solutions that are developed. Deliver reports, dashboards and other metrics as needed. Support and train end users on the Salesforce. Work collaboratively with other staff and departments. Perform other duties as assigned. Minimum Qualifications Bachelor's degree in Information Systems, Information Technology, Computer Science, Engineering or related discipline or equivalent combination of related education and relevant work experience. Experience as a Salesforce Developer. Two or more Professional Salesforce Certifications (i.e. Developer). Required Qualifications Solid knowledge of Object Oriented Design and Programming techniques. Good understanding of data structures, data modeling and database schema. Ability to independently perform development, testing, QA, implementation, documentation and updating as it relates to the Salesforce solutions and system administration. Proficiency in writing Apex code and triggers, lightning components, SOQL, SOSL, etc. Knowledge in developing and deploying solutions using Salesforce Lightning (Lightning Design System/Lightning App Builder/Lightning components). Strong understanding of relational databases. Experience in web programming, database design, SQL, data integration as well as experience with scripting languages, such as Java, Apex, or similar. Experience with cloud based products. Experience documenting and analyzing processes, procedures, and/or policies. Ability to handle full workload and meet deadlines. Ability to work with end users to define functional requirements and to translate those requirements into technical specifications. Excellent verbal, written and interpersonal communication skills. Creativity in finding solutions quickly and accurately. Attention to detail in communicating technical issues and implementing solutions. Customer service attitude and willingness to work in a cross functional team. Preferred Skills and Knowledge Five (5) or more years of experience as a Salesforce Developer. Experience integrating Salesforce with external systems using connectors, SOAP/REST API, Boomi, or other middleware. Detailed experience writing Visualforce and Apex classes and triggers. Knowledge of Salesforce security and sharing model. Knowledge of Salesforce API Development and Consumption. Experience with scripted data loader, web services, cloud or on premise middleware and other enterprise integration technologies. Expertise in declarative configuration - Flow, triggers, process builder, formulas, validations, etc. Knowledge and proficiency in web technologies such as CSS3, HTML5, Ajax, JavaScript, Bootstrap, Angular JS. Experience developing with PostgreSQL, Oracle and /or SQL Server. Experience in Salesforce Education Cloud (Marketing Cloud, Sales Cloud, Service Cloud, Community Cloud, EDA). Experience in working for Higher Education, non-profit, or government environments. Condition(s) of Employment Satisfactory completion of a background check (including LiveScan, as appropriate), that may include, but is not limited to: criminal records check, verification of academic credentials, licenses, certificates, credit history, professional references and/or verification of work history is required for employment. Cal State East Bay will issue a conditional offer of employment to the selected candidate, which may be rescinded if the background check reveals disqualifying information, and/or it is discovered that the candidate knowingly withheld or falsified information. Unsatisfactory results may also affect the continued employment of current Cal State East Bay employees who were conditionally offered the position. All background checks are conducted through the university's third party vendor, Accurate. LiveScan is conducted through the University Police Department. EEO Statement As an Equal Opportunity Employer, Cal State East Bay does not discriminate on the basis of any protected categories: age, ancestry, citizenship, color, disability, gender, immigration status, marital status, national origin, race, religion, sexual orientation, or veteran's status. The University is committed to the principles of diversity in employment and to creating a stimulating learning environment for its diverse student body. Other Information All California State University campuses, including Cal State East Bay, are smoke and tobacco-free. For more information, please visit our website here. In compliance with state and federal crime awareness and campus security legislation, including The Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act, the Cal State East Bay Annual Campus Security Report is available here. Sponsorship Cal State East Bay is not a sponsoring agency for Staff or Management positions and we are not an E-Verify employer. Mandated Reporter The incumbent in this position may be considered a mandated reporter under the California Child Abuse and Neglect Reporting Act and will be required to comply with requirements set forth in the CSU Executive Order 1083 as a condition of employment. Advertised: Feb 07 2024 Pacific Standard Time Applications close: Jun 07 2024 Pacific Daylight Time Closing Date/Time:
Salary and Benefits PLEASE NOTE: The starting salary placement depends on qualifications and experience and is anticipated to be in the range of $7,500.00 per month to $9,584.00 per month. Cal State East Bay offers a broad range of benefits that includes medical, dental, vision, retirement (CalPERS), 401k, 457, 403(b), dependent and health care reimbursement accounts, life insurance, vacation and sick, 14 paid holidays, one personal holiday and tuition fee waiver. For more information on the benefits program, please visit our benefits website. The CSU Total Compensation Calculator demonstrates the significance of our benefits package. This position may be eligible to participate in the Cal State East Bay hybrid telecommute program subject to management approval. Classification Analyst/Programmer - Expert About Cal State East Bay Cal State East Bay's beautiful main campus is located in the Hayward hills with panoramic views of the San Francisco Bay shoreline. Situated above the city of Hayward, the campus offers an ideal setting for teaching and learning and yet easy access to the many cities along the bay. The University has a satellite campus in Concord, a professional development center in Oakland and a significant presence online. Founded in 1957, Cal State East Bay is one of 23 universities of the California State University system (CSU). Cal State East Bay is recognized as a regionally engaged and globally oriented university with a strong commitment to academic innovation, student success, engaged and service learning, diversity, and sustainability. About the Position This is a full-time, temporary position through December 31, 2024 with the possibility of re-appointment. Cal State East Bay’s enterprise-wide CRM (Customer Relationship Management) implementation program, Compass, is scaling at lightning speed! We are looking to expand our CRM development team in central ITS. This is a great opportunity for a Salesforce developer who is highly motivated to grow and transform Higher Education. We are seeking a candidate who is committed to excellence in customer service, technical expertise and development. Join our team to deliver high-impact and meaningful projects focused on student success! This is a senior level position responsible for designing, developing, and supporting innovative Salesforce (CRM) solutions to support faculty, staff and student success initiatives. This position works with project manager(s), solution partners, other technical team members and third-party applications/managed packages to expand the depth and breadth of the University’s CRM ecosystem. Responsibilities Work on multiple projects from requirements gathering through solution design, build, testing, and deployment. Perform the build activities to deliver a solution from the design stage, to prototype, to a functional application. Develop applications using the Salesforce platform (Apex classes/triggers, Web Services API, be proficient in visual Flows), Angular JS, related web technologies (CSS3, HTML5, Ajax, JavaScript) and other enterprise programming languages such as Java. Implement new enhancements including creation of custom objects, workflows, email alerts and templates and campaigns. Develop, integrate, and maintain Salesforce with third party solutions or web services, including but not limited to PeopleSoft, Canvas, Tableau, and other higher education applications. Solve complex business problems. Participate in design and code reviews to ensure development quality. Execute unit tests and write Apex test classes for code coverage. Use development tools such as Eclipse IDE (for source code editor, debugging and deployment) and GIT (for source code and version control). Deploy metadata (configuration and code) to different environments via tools such as Ant and Flosum. Use tools such as Data Loader for data export, backup and migration between environments. Design user interfaces and create corresponding data relationship diagram(s) using LucidChart or similar tools to represent the data models and illustrate relationships between database elements. Create process flow diagrams to represent the logic and algorithms used to implement the business rules and requirements. Create and maintain user roles, security, permissions, profiles, workflow rules, etc. Understand the data architecture of SaaS products (i.e. Salesforce, Tableau), iPaaS products (i.e. Dell Boomi), and third-party open-source (i.e. MySQL) and commercial (i.e. PeopleSoft) software applications, and other SaaS products (i.e. FormAssembly) sources that integrate Salesforce CRM. Stay current with latest releases, maintenance packs/patches, and upgrades. Perform problem diagnosis and resolution. Use advanced troubleshooting and analysis to resolve problems at the root cause. Apply technical skills and creative problem-solving techniques to ensure customer issues are resolved in a timely manner. Integrate security into Software Development Life Cycle (SDLC) and provide technical documentation, work methodologies, best practices and repeatable processes. Ensure CSU Accessible Technology Initiative (ATI) standards are incorporated in all solutions that are developed. Deliver reports, dashboards and other metrics as needed. Support and train end users on the Salesforce. Work collaboratively with other staff and departments. Perform other duties as assigned. Minimum Qualifications Bachelor's degree in Information Systems, Information Technology, Computer Science, Engineering or related discipline or equivalent combination of related education and relevant work experience. Experience as a Salesforce Developer. Two or more Professional Salesforce Certifications (i.e. Developer). Required Qualifications Solid knowledge of Object Oriented Design and Programming techniques. Good understanding of data structures, data modeling and database schema. Ability to independently perform development, testing, QA, implementation, documentation and updating as it relates to the Salesforce solutions and system administration. Proficiency in writing Apex code and triggers, lightning components, SOQL, SOSL, etc. Knowledge in developing and deploying solutions using Salesforce Lightning (Lightning Design System/Lightning App Builder/Lightning components). Strong understanding of relational databases. Experience in web programming, database design, SQL, data integration as well as experience with scripting languages, such as Java, Apex, or similar. Experience with cloud based products. Experience documenting and analyzing processes, procedures, and/or policies. Ability to handle full workload and meet deadlines. Ability to work with end users to define functional requirements and to translate those requirements into technical specifications. Excellent verbal, written and interpersonal communication skills. Creativity in finding solutions quickly and accurately. Attention to detail in communicating technical issues and implementing solutions. Customer service attitude and willingness to work in a cross functional team. Preferred Skills and Knowledge Five (5) or more years of experience as a Salesforce Developer. Experience integrating Salesforce with external systems using connectors, SOAP/REST API, Boomi, or other middleware. Detailed experience writing Visualforce and Apex classes and triggers. Knowledge of Salesforce security and sharing model. Knowledge of Salesforce API Development and Consumption. Experience with scripted data loader, web services, cloud or on premise middleware and other enterprise integration technologies. Expertise in declarative configuration - Flow, triggers, process builder, formulas, validations, etc. Knowledge and proficiency in web technologies such as CSS3, HTML5, Ajax, JavaScript, Bootstrap, Angular JS. Experience developing with PostgreSQL, Oracle and /or SQL Server. Experience in Salesforce Education Cloud (Marketing Cloud, Sales Cloud, Service Cloud, Community Cloud, EDA). Experience in working for Higher Education, non-profit, or government environments. Condition(s) of Employment Satisfactory completion of a background check (including LiveScan, as appropriate), that may include, but is not limited to: criminal records check, verification of academic credentials, licenses, certificates, credit history, professional references and/or verification of work history is required for employment. Cal State East Bay will issue a conditional offer of employment to the selected candidate, which may be rescinded if the background check reveals disqualifying information, and/or it is discovered that the candidate knowingly withheld or falsified information. Unsatisfactory results may also affect the continued employment of current Cal State East Bay employees who were conditionally offered the position. All background checks are conducted through the university's third party vendor, Accurate. LiveScan is conducted through the University Police Department. EEO Statement As an Equal Opportunity Employer, Cal State East Bay does not discriminate on the basis of any protected categories: age, ancestry, citizenship, color, disability, gender, immigration status, marital status, national origin, race, religion, sexual orientation, or veteran's status. The University is committed to the principles of diversity in employment and to creating a stimulating learning environment for its diverse student body. Other Information All California State University campuses, including Cal State East Bay, are smoke and tobacco-free. For more information, please visit our website here. In compliance with state and federal crime awareness and campus security legislation, including The Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act, the Cal State East Bay Annual Campus Security Report is available here. Sponsorship Cal State East Bay is not a sponsoring agency for Staff or Management positions and we are not an E-Verify employer. Mandated Reporter The incumbent in this position may be considered a mandated reporter under the California Child Abuse and Neglect Reporting Act and will be required to comply with requirements set forth in the CSU Executive Order 1083 as a condition of employment. Advertised: Feb 07 2024 Pacific Standard Time Applications close: Jun 07 2024 Pacific Daylight Time Closing Date/Time:
City of Los Angeles
City Of Los Angeles, California, United States
DUTIES ANNUAL SALARY: $112,564 to $164,576 The salary in the Department of Water and Power is $138,058 to $171,529. NOTES : Annual salary is at the start of the pay range. The current salary range is subject to change. Please confirm the starting salary with the hiring department before accepting a job offer. For information regarding reciprocity between the City of Los Angeles departments and LADWP, go to http://per.lacity.org/Reciprocity_CityDepts_and_DWP.pdf . A Database Architect performs technical and administrative work in the development of standards, methods, techniques, policies, procedures, data analyses, data designs, database implementations, and data governance necessary for the productive integration, sharing, standardization, integrity, security, availability, consistency, and usability of data throughout the City’s on-premises and cloud-based databases; assists in the implementation, maintenance, operation, or overall management of and database-level integration between the on-premises and cloud-based databases; installs and configures database software and related administration tools and utilities; develops and implements production scripts for database maintenance tasks; tunes and optimizes SQL statements and database/system parameters; develops and conducts training; utilizes database tools to perform various types of database backups and recoveries; ensures database security and compliance with SB1386 or data privacy acts; researches current database issues and technologies; assists application developer to apply sound database technology to new application; may supervise other technical employees in the performance of this work; and performs related duties. REQUIREMENT(S)/MINIMUM QUALIFICATION(S) A bachelor’s degree from an accredited four-year college or university in information systems, software engineering, computer engineering, computer science, or a related field; AND ONE OF THE FOLLOWING : Two years of full-time paid experience installing, administering, tuning, and maintaining databases in a medium to large scale production environment in one of the following database platforms: Oracle, DB2, SQL Server, MySQL, MariaDB, or PostgreSQL in a position at the level of Senior Systems Analyst I, Systems Programmer I, or Programmer Analyst IV with the City of Los Angeles; OR Two years of full-time paid experience as a database architect or database administrator in the information technology industry installing, administering, tuning, and maintaining medium to large scale production databases in one of the following database platforms: Oracle, DB2, SQL Server, MySQL, MariaDB, or PostgreSQL; OR Two years of full-time paid experience designing, building, operationalizing, securing, monitoring, and maintaining Google Cloud Platform or comparable cloud computing platforms using applicable data infrastructure such as Google Cloud Storage, Google BigQuery, Google CloudSQL, and Google Cloud Run for data processing in a position at the level of Senior Systems Analyst I, Systems Programmer I, or Programmer Analyst IV with the City of Los Angeles; OR Two years of full-time paid experience as a database architect or database administrator in the information technology industry designing, building, operationalizing, securing, monitoring, and maintaining Google Cloud Platform or comparable cloud computing platforms using applicable data infrastructure such as Google Cloud Storage, Google BigQuery, Google CloudSQL, and Google Cloud Run for data processing. A DBA professional certification in one of the following databases may be substituted for up to one year of the required experience: Oracle Database, version 10g or higher - Any operating system, Oracle Certified Professional (OCP) DB2 Universal Database, version 11 or higher - Any operating system, IBM Certified Database Administrator Microsoft SQL Server version 2012 or higher - Microsoft Certified Database Administrator (MCDBA) MySQL 5.7 or higher - Any operating system, MySQL Certified Database Administrator MariaDB version 10 or higher - Any operating system, MariaDB Certified Database Administrator PostgreSQL, version 12 - Any operating system, PostgreSQL Professional Certification Google Certified Professional Data Engineer PROCESS NOTES: Applicants who lack six months or less of the required experience may file for this examination. However, they cannot be appointed until the full experience requirement is met. Some positions may require a valid California driver’s license. Candidates may not be eligible for appointment to these positions if their record within the last 36 months reflects three or more moving violations and/or at-fault accidents, or a conviction of a major moving violation (such as DUI). Applicants must list their school name and location, type of degree earned and major in the Education Section of the application. Applicants who fail to provide this information on their application will not be considered further in this examination and their applications will not be processed. Please note that qualifying education must be from a college or university accredited by a City of Los Angeles recognized agency. A list of approved accrediting agencies can be found at http://per.lacity.org/Accredited%20Institutions%2008-21-08.pdf . Candidates completing the examination process will be contacted by the Personnel Department to provide required proof of qualifying degree. Applicants who wish to expedite this process may attach a copy of their qualifying degree to their on-line application at the time of filing in the Attachments section. Applicants wishing to substitute a DBA professional certification for up to one year of the required experience in Requirement #2, #3, #4, or #5 must attach proof of completion of the DBA professional certification at the time of filing in the Attachments section. The copy of the document(s) must be attached to the on-line application BEFORE the application is submitted. If the document(s) is attached AFTER the on-line application has been submitted, it will not be available to the City and applicants WILL NOT be credited with having submitted the documents. The substitution will not be considered for applicants who fail to provide the information at the time of filing. Please note that the following DBA professional certifications listed under the substitution clause may be updated in future exam bulletins to: Oracle Database, version 19c or higher - Any operating system, Oracle Certified Professional (OCP) DB2 Universal Database, version 12 or higher - Any operating system, IBM Certified Database Administrator Microsoft SQL Server version 2016 or higher - Microsoft Certified Database Administrator (MCDBA) SELECTIVE CERTIFICATION: In accordance with Charter Section 1010 (b) and Civil Service Rule 5.31, selective certification will be used for some positions that require special skills and/or training. Only persons possessing the following specific professional certification(s) at the time of filing may be considered for appointment to fill such positions: AWS Certified Database-Specialty Certification Google Certified Professional Data Engineer IBM Certified Database Administrator - DB2 8 or higher (Linux, UNIX, and Windows) IBM Certified Database Administrator - DB2 9 or higher for z/OS IBM Certified Database Administrator - DB2 v12 or higher for z/OS IBM InfoSphere DataStage Badge Essentials MariaDB Certified Database Administrator - MariaDB version 10 or higher Microsoft Certified: Azure Database Administrator Associate Microsoft Certified Database Administrator (MCDBA) Microsoft Certified Solutions Associate (MCSA) Microsoft SQL 2016 Database Administration Microsoft Certified Solutions Expert (MCSE) - Data Management and Analytics Microsoft Certified Solutions Associate (MCSA) - SQL Database Administration Microsoft Certified Solutions Associate (MCSA): Data Engineering with Azure Microsoft Certified Solutions Associate (MCSA) - SQL 2016 Database Administration Microsoft Certified Solutions Associate (MSCA): SQL 2016 BI Development or more recent MySQL Certified Database Administrator - MySQL 5.7 or higher Oracle 10g Administrator Certified Associate (OCA) or higher Oracle 10g Administrator Certified Master (OCM) or higher Oracle 10g Administrator Certified Professional (OCP) or higher Oracle 12c Administrator Certified Associate (OCA) or higher Oracle 12c Administrator Certified Master (OCM) or higher Oracle 19c Administrator Certified Professional (OCP) or higher Oracle Data Integrator 11g or 12c (or higher) Certified Implementation Specialist Oracle E-Business Suite R12 PostgreSQL Professional Certification - PostgreSQL version 12 or higher PowerCenter Data Integration 10 or higher: Administrator, Specialist Certification PowerCenter Data Integration 10 or higher: Developer, Specialist Certification NOTE : Applicants must attach a copy of the certificate(s) to the on-line application at the time of filing. The certificate(s) must be attached to the on-line application BEFORE the application is submitted. If the certificate(s) is attached AFTER the on-line application has been submitted, it will not be available to the City and applicants WILL NOT be credited with having submitted the certificate(s), and will not be considered for this part of selective certification. WHERE TO APPLY & APPLICATION DEADLINE Applications will only be accepted on-line on the dates listed in the “Application Deadline” section of this bulletin. When you are viewing the on-line job bulletin of your choice, simply scroll to the top of the page and select the “Apply” icon. On-line job bulletins are also available at https://www.governmentjobs.com/careers/lacity . NOTE : Applicants are urged to apply early to ensure you have time to resolve any technical issues you may encounter. Applications will only be accepted on-line on the dates listed below: Friday, October 6, 2023 to Thursday, October 19, 2023 Friday, May 3, 2024 to Thursday, May 16, 2024 The examination may close without prior notice at any time after a sufficient number of applications have been received. Filing periods may change without prior notice or additional dates may be added, as needed, at a later date. For administrative purposes, filing will close periodically and reopen on the dates noted in the “Application Deadline” section of this bulletin. In accordance with Civil Service Rule 4.2, all applicants who apply may not be tested in this examination. To meet anticipated hiring needs, only a limited number of qualified applicants will be invited to participate in the selection process in the following order: 1) Los Angeles City promotional applicants who meet the minimum requirements. You must have received a regular appointment to a City position or be on a reserve list to apply for this examination as a promotional candidate; 2) Applicants currently employed by the City of Los Angeles on a part-time or exempt basis who meet the minimum requirements; 3) Remaining applicants who meet the minimum requirements in sufficient numbers to meet hiring needs based on a random sampling of those qualified candidates. Applicants not selected to be tested may re-apply in a subsequent filing period in order to be considered for that period’s selection process. SELECTION PROCESS Examination Weights: Technical Exercise: Advisory Interview: 100% The examination will consist entirely of an evaluation of professional and personal qualifications by interview. In the interview, the following competencies may be evaluated: Analytical Ability; Attention to Detail; Initiative; Innovation; Responsiveness and Follow-Up; Teamwork; Oral Communication; Job Knowledge, including knowledge of: high-availability, high-performance, and disaster recovery databases; data management principles, data flow, and systems design theory; database tuning methods; database design principles and conceptual modeling techniques; general query and transaction processing concepts; metadata repository concepts; data arrangement and distribution; performance trade-offs, data structures, and relative strengths and weaknesses of database management systems; programming languages; control systems software and native or third-party tools; internal systems components; various relational database management schemas; software tools and technologies necessary to move or replicate data; Google Cloud platform functionalities; and other necessary knowledge, skills, and abilities. Additional job analysis information can be obtained by going to https://per.lacity.org/jobs/job-analyses.cfm and clicking on Competencies under Database Architect. Prior to the interview, candidates will be required to prepare some technical, written material related to the duties and responsibilities of a Database Architect. This material will not be separately scored, but will be presented to the interview board for review and consideration, which may include discussion, in the overall evaluation of the candidate. Those who do not complete the advisory technical exercise will not be invited to the interview and will be considered to have failed the entire examination. To be considered complete, the advisory technical exercise must include a substantive response for each question or problem included in the advisory technical exercise for which a candidate is required to provide an answer. Please note that candidates must complete the advisory technical exercise and meet the minimum qualifications as stated on this bulletin in order to be considered further in the examination process. The advisory technical exercise will be administered on-line . Candidates invited to participate in the examination will receive an e-mail from the City of Los Angeles outlining the specific steps needed to complete the on-line advisory technical exercise. Candidates who fail to complete the advisory technical exercise as instructed may be disqualified. For candidates who apply between FRIDAY, OCTOBER 6, 2023 and THURSDAY, OCTOBER 19, 2023 , it is anticipated that the on-line advisory technical exercise will be administered between MONDAY, NOVEMBER 27, 2023 and MONDAY, DECEMBER 4, 2023 . For candidates who apply between FRIDAY, MAY 3, 2024 and THURSDAY, MAY 16, 2024 , it is anticipated that the on-line advisory technical exercise will be administered between MONDAY, JUNE 24, 2024 and MONDAY, JULY 1, 2024 . Candidates will be notified later by e-mail of the date, time, and location of the interview, which will be held in Los Angeles or on-line. For candidates who apply between FRIDAY, OCTOBER 6, 2023 and THURSDAY, OCTOBER 19, 2023 , it is anticipated that interviews will begin during the period of DECEMBER 26, 2023 to JANUARY 5, 2024 . For candidates who apply between FRIDAY, MAY 3, 2024 and THURSDAY, MAY 16, 2024 , it is anticipated that interviews will begin during the period of July 22, 2024 to August 2, 2024. NOTES : This examination is based on a validation study. As a covered entity under the Fair Employment and Housing Act and Title II of the Americans with Disabilities Act, the City of Los Angeles does not discriminate on the basis of disability and upon request, will provide reasonable accommodations to ensure equal access to its programs, services, and activities. To request a disability accommodation, please complete the Disability Accommodation Form within 14 calendar days of the submittal of the City application. The Disability Accommodation Form can be obtained at http://per.lacity.org/exams/verify_disability.pdf . Applications are accepted subject to review to ensure that minimum qualifications are met. Candidates may be disqualified at any time if it is determined that they do not possess the minimum qualifications stated on this bulletin. In conjunction with Civil Service Rules, applicants who have received a regular appointment to a City position or are on a reserve list will be considered Promotional candidates while all other applicants will be considered Open candidates. The promotional list will ordinarily be used ahead of the open competitive list. However, if open competitive candidates receive a higher score, without military credits, than the highest available promotional candidate, after adding 0.25 of a point seniority credit for each year of continuous classified City service, the Civil Service Commission, upon request of the appointing authority, may approve certification of such open competitive candidates ahead of the promotional candidates. You may take the Database Architect advisory technical exercise only once every 24 months under this bulletin. If you have taken the Database Architect advisory technical exercise within the last 24 months, you may not file for this examination at this time. Your rank on the employment list may change as scores of candidates from other administrations of this examination are merged onto one list. Your name may be removed from the open competitive list after six (6) months. A final average score of 70% or higher is required to be placed on the eligible list. In accordance with Civil Service Rule, Sec. 4.24, review periods may be combined. Candidates in the examination process may file protests as provided in Sec. 4.20, 4.22, and 4.23 as applicable and within the required time frame; however, the Personnel Department may respond to and resolve protests prior to the establishment of the eligible list. For candidates seeking initial City employment, in accordance with Los Angeles City Ordinance 187134, information regarding COVID-19 vaccination requirements as conditions of employment may be found at: https://clkrep.lacity.org/onlinedocs/2021/21-0921_ord_187134_8-24-21.pdf . Notice : If you receive and accept an offer of employment to a regular position with the City of Los Angeles, your employee benefit coverage (including health and dental coverage as well as life insurance) will commence approximately six weeks after your original regular appointment. Not all positions in the City receive benefit coverage; you should inquire regarding the availability of employee benefits prior to accepting a position. All City employees are required to be Disaster Service Workers. THIS EXAMINATION IS TO BE GIVEN BOTH ON AN INTERDEPARTMENTAL PROMOTIONAL AND OPEN COMPETITIVE BASIS The City of Los Angeles does not discriminate on the basis of race, religion, national origin, sex, age, marital status, sexual orientation, gender identity, gender expression, disability, creed, color, ancestry, medical condition (cancer), or Acquired Immune Deficiency Syndrome. AN EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER For additional information and FAQs regarding the City's hiring process, please go to: https://per.lacity.org/faqs/employment-testing-process.html There are many things to consider in a new employer. Visit the following webpage to view benefits the City of Los Angeles offers its employees: http://per.lacity.org/bens/index.html Closing Date/Time: Continuous
DUTIES ANNUAL SALARY: $112,564 to $164,576 The salary in the Department of Water and Power is $138,058 to $171,529. NOTES : Annual salary is at the start of the pay range. The current salary range is subject to change. Please confirm the starting salary with the hiring department before accepting a job offer. For information regarding reciprocity between the City of Los Angeles departments and LADWP, go to http://per.lacity.org/Reciprocity_CityDepts_and_DWP.pdf . A Database Architect performs technical and administrative work in the development of standards, methods, techniques, policies, procedures, data analyses, data designs, database implementations, and data governance necessary for the productive integration, sharing, standardization, integrity, security, availability, consistency, and usability of data throughout the City’s on-premises and cloud-based databases; assists in the implementation, maintenance, operation, or overall management of and database-level integration between the on-premises and cloud-based databases; installs and configures database software and related administration tools and utilities; develops and implements production scripts for database maintenance tasks; tunes and optimizes SQL statements and database/system parameters; develops and conducts training; utilizes database tools to perform various types of database backups and recoveries; ensures database security and compliance with SB1386 or data privacy acts; researches current database issues and technologies; assists application developer to apply sound database technology to new application; may supervise other technical employees in the performance of this work; and performs related duties. REQUIREMENT(S)/MINIMUM QUALIFICATION(S) A bachelor’s degree from an accredited four-year college or university in information systems, software engineering, computer engineering, computer science, or a related field; AND ONE OF THE FOLLOWING : Two years of full-time paid experience installing, administering, tuning, and maintaining databases in a medium to large scale production environment in one of the following database platforms: Oracle, DB2, SQL Server, MySQL, MariaDB, or PostgreSQL in a position at the level of Senior Systems Analyst I, Systems Programmer I, or Programmer Analyst IV with the City of Los Angeles; OR Two years of full-time paid experience as a database architect or database administrator in the information technology industry installing, administering, tuning, and maintaining medium to large scale production databases in one of the following database platforms: Oracle, DB2, SQL Server, MySQL, MariaDB, or PostgreSQL; OR Two years of full-time paid experience designing, building, operationalizing, securing, monitoring, and maintaining Google Cloud Platform or comparable cloud computing platforms using applicable data infrastructure such as Google Cloud Storage, Google BigQuery, Google CloudSQL, and Google Cloud Run for data processing in a position at the level of Senior Systems Analyst I, Systems Programmer I, or Programmer Analyst IV with the City of Los Angeles; OR Two years of full-time paid experience as a database architect or database administrator in the information technology industry designing, building, operationalizing, securing, monitoring, and maintaining Google Cloud Platform or comparable cloud computing platforms using applicable data infrastructure such as Google Cloud Storage, Google BigQuery, Google CloudSQL, and Google Cloud Run for data processing. A DBA professional certification in one of the following databases may be substituted for up to one year of the required experience: Oracle Database, version 10g or higher - Any operating system, Oracle Certified Professional (OCP) DB2 Universal Database, version 11 or higher - Any operating system, IBM Certified Database Administrator Microsoft SQL Server version 2012 or higher - Microsoft Certified Database Administrator (MCDBA) MySQL 5.7 or higher - Any operating system, MySQL Certified Database Administrator MariaDB version 10 or higher - Any operating system, MariaDB Certified Database Administrator PostgreSQL, version 12 - Any operating system, PostgreSQL Professional Certification Google Certified Professional Data Engineer PROCESS NOTES: Applicants who lack six months or less of the required experience may file for this examination. However, they cannot be appointed until the full experience requirement is met. Some positions may require a valid California driver’s license. Candidates may not be eligible for appointment to these positions if their record within the last 36 months reflects three or more moving violations and/or at-fault accidents, or a conviction of a major moving violation (such as DUI). Applicants must list their school name and location, type of degree earned and major in the Education Section of the application. Applicants who fail to provide this information on their application will not be considered further in this examination and their applications will not be processed. Please note that qualifying education must be from a college or university accredited by a City of Los Angeles recognized agency. A list of approved accrediting agencies can be found at http://per.lacity.org/Accredited%20Institutions%2008-21-08.pdf . Candidates completing the examination process will be contacted by the Personnel Department to provide required proof of qualifying degree. Applicants who wish to expedite this process may attach a copy of their qualifying degree to their on-line application at the time of filing in the Attachments section. Applicants wishing to substitute a DBA professional certification for up to one year of the required experience in Requirement #2, #3, #4, or #5 must attach proof of completion of the DBA professional certification at the time of filing in the Attachments section. The copy of the document(s) must be attached to the on-line application BEFORE the application is submitted. If the document(s) is attached AFTER the on-line application has been submitted, it will not be available to the City and applicants WILL NOT be credited with having submitted the documents. The substitution will not be considered for applicants who fail to provide the information at the time of filing. Please note that the following DBA professional certifications listed under the substitution clause may be updated in future exam bulletins to: Oracle Database, version 19c or higher - Any operating system, Oracle Certified Professional (OCP) DB2 Universal Database, version 12 or higher - Any operating system, IBM Certified Database Administrator Microsoft SQL Server version 2016 or higher - Microsoft Certified Database Administrator (MCDBA) SELECTIVE CERTIFICATION: In accordance with Charter Section 1010 (b) and Civil Service Rule 5.31, selective certification will be used for some positions that require special skills and/or training. Only persons possessing the following specific professional certification(s) at the time of filing may be considered for appointment to fill such positions: AWS Certified Database-Specialty Certification Google Certified Professional Data Engineer IBM Certified Database Administrator - DB2 8 or higher (Linux, UNIX, and Windows) IBM Certified Database Administrator - DB2 9 or higher for z/OS IBM Certified Database Administrator - DB2 v12 or higher for z/OS IBM InfoSphere DataStage Badge Essentials MariaDB Certified Database Administrator - MariaDB version 10 or higher Microsoft Certified: Azure Database Administrator Associate Microsoft Certified Database Administrator (MCDBA) Microsoft Certified Solutions Associate (MCSA) Microsoft SQL 2016 Database Administration Microsoft Certified Solutions Expert (MCSE) - Data Management and Analytics Microsoft Certified Solutions Associate (MCSA) - SQL Database Administration Microsoft Certified Solutions Associate (MCSA): Data Engineering with Azure Microsoft Certified Solutions Associate (MCSA) - SQL 2016 Database Administration Microsoft Certified Solutions Associate (MSCA): SQL 2016 BI Development or more recent MySQL Certified Database Administrator - MySQL 5.7 or higher Oracle 10g Administrator Certified Associate (OCA) or higher Oracle 10g Administrator Certified Master (OCM) or higher Oracle 10g Administrator Certified Professional (OCP) or higher Oracle 12c Administrator Certified Associate (OCA) or higher Oracle 12c Administrator Certified Master (OCM) or higher Oracle 19c Administrator Certified Professional (OCP) or higher Oracle Data Integrator 11g or 12c (or higher) Certified Implementation Specialist Oracle E-Business Suite R12 PostgreSQL Professional Certification - PostgreSQL version 12 or higher PowerCenter Data Integration 10 or higher: Administrator, Specialist Certification PowerCenter Data Integration 10 or higher: Developer, Specialist Certification NOTE : Applicants must attach a copy of the certificate(s) to the on-line application at the time of filing. The certificate(s) must be attached to the on-line application BEFORE the application is submitted. If the certificate(s) is attached AFTER the on-line application has been submitted, it will not be available to the City and applicants WILL NOT be credited with having submitted the certificate(s), and will not be considered for this part of selective certification. WHERE TO APPLY & APPLICATION DEADLINE Applications will only be accepted on-line on the dates listed in the “Application Deadline” section of this bulletin. When you are viewing the on-line job bulletin of your choice, simply scroll to the top of the page and select the “Apply” icon. On-line job bulletins are also available at https://www.governmentjobs.com/careers/lacity . NOTE : Applicants are urged to apply early to ensure you have time to resolve any technical issues you may encounter. Applications will only be accepted on-line on the dates listed below: Friday, October 6, 2023 to Thursday, October 19, 2023 Friday, May 3, 2024 to Thursday, May 16, 2024 The examination may close without prior notice at any time after a sufficient number of applications have been received. Filing periods may change without prior notice or additional dates may be added, as needed, at a later date. For administrative purposes, filing will close periodically and reopen on the dates noted in the “Application Deadline” section of this bulletin. In accordance with Civil Service Rule 4.2, all applicants who apply may not be tested in this examination. To meet anticipated hiring needs, only a limited number of qualified applicants will be invited to participate in the selection process in the following order: 1) Los Angeles City promotional applicants who meet the minimum requirements. You must have received a regular appointment to a City position or be on a reserve list to apply for this examination as a promotional candidate; 2) Applicants currently employed by the City of Los Angeles on a part-time or exempt basis who meet the minimum requirements; 3) Remaining applicants who meet the minimum requirements in sufficient numbers to meet hiring needs based on a random sampling of those qualified candidates. Applicants not selected to be tested may re-apply in a subsequent filing period in order to be considered for that period’s selection process. SELECTION PROCESS Examination Weights: Technical Exercise: Advisory Interview: 100% The examination will consist entirely of an evaluation of professional and personal qualifications by interview. In the interview, the following competencies may be evaluated: Analytical Ability; Attention to Detail; Initiative; Innovation; Responsiveness and Follow-Up; Teamwork; Oral Communication; Job Knowledge, including knowledge of: high-availability, high-performance, and disaster recovery databases; data management principles, data flow, and systems design theory; database tuning methods; database design principles and conceptual modeling techniques; general query and transaction processing concepts; metadata repository concepts; data arrangement and distribution; performance trade-offs, data structures, and relative strengths and weaknesses of database management systems; programming languages; control systems software and native or third-party tools; internal systems components; various relational database management schemas; software tools and technologies necessary to move or replicate data; Google Cloud platform functionalities; and other necessary knowledge, skills, and abilities. Additional job analysis information can be obtained by going to https://per.lacity.org/jobs/job-analyses.cfm and clicking on Competencies under Database Architect. Prior to the interview, candidates will be required to prepare some technical, written material related to the duties and responsibilities of a Database Architect. This material will not be separately scored, but will be presented to the interview board for review and consideration, which may include discussion, in the overall evaluation of the candidate. Those who do not complete the advisory technical exercise will not be invited to the interview and will be considered to have failed the entire examination. To be considered complete, the advisory technical exercise must include a substantive response for each question or problem included in the advisory technical exercise for which a candidate is required to provide an answer. Please note that candidates must complete the advisory technical exercise and meet the minimum qualifications as stated on this bulletin in order to be considered further in the examination process. The advisory technical exercise will be administered on-line . Candidates invited to participate in the examination will receive an e-mail from the City of Los Angeles outlining the specific steps needed to complete the on-line advisory technical exercise. Candidates who fail to complete the advisory technical exercise as instructed may be disqualified. For candidates who apply between FRIDAY, OCTOBER 6, 2023 and THURSDAY, OCTOBER 19, 2023 , it is anticipated that the on-line advisory technical exercise will be administered between MONDAY, NOVEMBER 27, 2023 and MONDAY, DECEMBER 4, 2023 . For candidates who apply between FRIDAY, MAY 3, 2024 and THURSDAY, MAY 16, 2024 , it is anticipated that the on-line advisory technical exercise will be administered between MONDAY, JUNE 24, 2024 and MONDAY, JULY 1, 2024 . Candidates will be notified later by e-mail of the date, time, and location of the interview, which will be held in Los Angeles or on-line. For candidates who apply between FRIDAY, OCTOBER 6, 2023 and THURSDAY, OCTOBER 19, 2023 , it is anticipated that interviews will begin during the period of DECEMBER 26, 2023 to JANUARY 5, 2024 . For candidates who apply between FRIDAY, MAY 3, 2024 and THURSDAY, MAY 16, 2024 , it is anticipated that interviews will begin during the period of July 22, 2024 to August 2, 2024. NOTES : This examination is based on a validation study. As a covered entity under the Fair Employment and Housing Act and Title II of the Americans with Disabilities Act, the City of Los Angeles does not discriminate on the basis of disability and upon request, will provide reasonable accommodations to ensure equal access to its programs, services, and activities. To request a disability accommodation, please complete the Disability Accommodation Form within 14 calendar days of the submittal of the City application. The Disability Accommodation Form can be obtained at http://per.lacity.org/exams/verify_disability.pdf . Applications are accepted subject to review to ensure that minimum qualifications are met. Candidates may be disqualified at any time if it is determined that they do not possess the minimum qualifications stated on this bulletin. In conjunction with Civil Service Rules, applicants who have received a regular appointment to a City position or are on a reserve list will be considered Promotional candidates while all other applicants will be considered Open candidates. The promotional list will ordinarily be used ahead of the open competitive list. However, if open competitive candidates receive a higher score, without military credits, than the highest available promotional candidate, after adding 0.25 of a point seniority credit for each year of continuous classified City service, the Civil Service Commission, upon request of the appointing authority, may approve certification of such open competitive candidates ahead of the promotional candidates. You may take the Database Architect advisory technical exercise only once every 24 months under this bulletin. If you have taken the Database Architect advisory technical exercise within the last 24 months, you may not file for this examination at this time. Your rank on the employment list may change as scores of candidates from other administrations of this examination are merged onto one list. Your name may be removed from the open competitive list after six (6) months. A final average score of 70% or higher is required to be placed on the eligible list. In accordance with Civil Service Rule, Sec. 4.24, review periods may be combined. Candidates in the examination process may file protests as provided in Sec. 4.20, 4.22, and 4.23 as applicable and within the required time frame; however, the Personnel Department may respond to and resolve protests prior to the establishment of the eligible list. For candidates seeking initial City employment, in accordance with Los Angeles City Ordinance 187134, information regarding COVID-19 vaccination requirements as conditions of employment may be found at: https://clkrep.lacity.org/onlinedocs/2021/21-0921_ord_187134_8-24-21.pdf . Notice : If you receive and accept an offer of employment to a regular position with the City of Los Angeles, your employee benefit coverage (including health and dental coverage as well as life insurance) will commence approximately six weeks after your original regular appointment. Not all positions in the City receive benefit coverage; you should inquire regarding the availability of employee benefits prior to accepting a position. All City employees are required to be Disaster Service Workers. THIS EXAMINATION IS TO BE GIVEN BOTH ON AN INTERDEPARTMENTAL PROMOTIONAL AND OPEN COMPETITIVE BASIS The City of Los Angeles does not discriminate on the basis of race, religion, national origin, sex, age, marital status, sexual orientation, gender identity, gender expression, disability, creed, color, ancestry, medical condition (cancer), or Acquired Immune Deficiency Syndrome. AN EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER For additional information and FAQs regarding the City's hiring process, please go to: https://per.lacity.org/faqs/employment-testing-process.html There are many things to consider in a new employer. Visit the following webpage to view benefits the City of Los Angeles offers its employees: http://per.lacity.org/bens/index.html Closing Date/Time: Continuous