Required Skills, Experience, and Education :
SALARY: $7,149 - $8,651/month
The Fresno Police Department is offering an outstanding career opportunity to a dedicated professional to manage the Police Departments databases, which include standards and procedures relating to the integrity of City-wide information systems; serving as an expert technical resource on database architecture, design, and administration; recommending and maintaining City-wide and industry standards for database design and database administration; and maintaining system security. Incumbents may serve as lead workers to other staff.The ideal candidate should be highly skilled in Oracle and/or Microsoft SQL Server databases (including Microsoft SQL Server 2012, 2016, 2017, and newer), operating systems (Windows, Linux, Unix), Esri SDE Geodatabases, as well as project management.Experience with Accela, human resource, financial, and utility billing applications are advantageous.
CONDITIONS OF EMPLOYMENTAs required by Emergency Order 2021-02, section 7.8, newly hired City employees are required to be fully vaccinated against COVID-19 regardless of the employee's duty location or work arrangement (e.g., telework, remote work, etc.), subject to such exceptions as required by law. If selected, you will be required to be fully vaccinated against COVID-19 and submit documentation of proof of vaccination before appointment or onboarding with the City or agree to weekly COVID-19 testing when required by the City. The City will provide additional information regarding what information or documentation will be needed and how you can request from the agency a legally required exception from this requirement.
3% salary increase, effective June 19, 2023
HEALTH INSURANCE: The City contributes toward monthly premiums for PPO medical, dental, and vision for employees and dependents.FLEXIBLE SPENDING ACCOUNT: IRS 125 Plan for health and dependent care expenses.DEFERRED COMPENSATION: Voluntary 457 plan with Fidelity Investments to increase your retirement savings.MANAGEMENT LEAVE: 60 hours per fiscal year for exempt employees.ANNUAL LEAVE: Accrue 15.5 hours per month with cash-out provisions.SUPPLEMENTAL SICK- 40 hours per fiscal year. 80 hours lifetime maximum HOLIDAYS: Ten (10) City-observed annual holidays plus birthdays and two (2) personal days.LIFE INSURANCE: Benefit equal to annual salary; premium paid by the City.LONG-TERM DISABILITY: Benefit equal to 66.66% of monthly salary up to $7,500 per month after 30 days of disability; premium paid by the City.BILINGUAL PREMIUM: PAY: $100 per month HEALTH REIMBURSEMENT ARRANGEMENT: To reimburse retirement medical insurance and qualified medical expenses.RETIREMENT: City of Fresno Retirement Systems, one of the best-funded public systems in the state.Reciprocity with other CA public agencies. Vested in Retirement benefits after 5 years of service. City employees do not participate in Social Security.DROP (Deferred Retirement Option Program): an optional, voluntary program that allows an employee to deposit retirement benefits in a special savings account within the Retirement System while continuing to work for the City of Fresno for up to 10 years. Participation minimum is age 50 and vested. Benefits include ownership of accumulated funds, compound interest earnings, and alternative distribution options.
A Bachelor's Degree from an accredited college or university with major course work in Computer Science, Business Administration, Information Systems, or related fields (A copy of the diploma must be scanned and attached to your online application).
Two (2) years of experience involving application development, operation, and maintenance of the system software, and database administration functions.
A copy of your degree or college transcripts must be uploaded and included in your online application for verification of the requirement. Applicants lacking the documentation may be rejected if relying upon education to meet the Minimum Requirements.
* HOW TO APPLY*
APPLICANTS MUST COMPLETE AN ONLINE APPLICATION. PLEASE CLICKHERE (https://jobs.fresno.gov/psp/cofcg/EMPLOYEE/HRMS/c/HRS_HRAM.HRS_CE.GBL?Page=HRS_CE_HM_PRE&Action=A&SiteId=1) TO APPLY.
The Database Administrator will join a high performing agile team using the Scaled Agile Framework (SAFe) methodology to support a nationally significant program. The program is using Behavior Driven Development (BDD) and test automation tools alongside a full suite of team collaboration tools. Program execution follows DEVOPS best practices and employs robust development, test, and production environments. The program provides system engineering, development, test, integration, and operational support to a large, fast-paced program, and is developing infusing new technology and adding advanced capabilities while continuing to support an on-going mission and operational system.
Job Summary and Primary Responsibilities
The selected individual must be able to efficiently investigate complex database issues and provide solutions in a dynamic, complex, production environment. He/she must have the ability to effectively interface with customers, system administrators, database team members, software developers, and senior-level management. He/she will be expected to learn and understand data models and data architecture documents. Solutions developed to support the customer's needs will be written using SQL, PL/SQL, and scripting languages. Other tasks may include applying Oracle patches and upgrading the database structure, as well as tasks in data conversion and other database-centric process improvements.
CONMDPay Range: Pay Range $74,750.00 - $115,000.00 - $155,250.00
Database Administrator (Remote)
ABOUT THIS POSITION
The successful Software Engineer candidate will be part of the KBR team supporting the Test Resource Management Centers (TRMC) Big Data (BD) and Knowledge Management (KM) Team working on prototype BD and KM systems for DoD test ranges and various acquisition programs. The candidate will be responsible for collecting and documenting use cases and requirements from stakeholders located at various Department of Defense (DoD) testing ranges and then either developing functioning software products to fulfill the documented requirements or handing the requirements off to other team members to develop. The developed tools will ultimately be integrated with TRMCs highly visible data analytic project supporting multiple DoD ranges called Cloud Hybrid Edge-to-Enterprise Evaluation & Test Analysis Suite (CHEETAS). The successful candidate will work with data science, data engineer, and software development teams to support our customers by demonstrating to DoD range stakeholders the art of the possible with CHEETAS and other standard commercial Big Data tools. This job will require interaction with DoD Range analysts and end users to discuss requirements and needs. This requires the ability to effectively communicate at both a programmatic and technical level. Candidates must have strong experience using a variety of relational and file-based databases using both commercial and open-source Big Data technologies and tools (ex. MS SQL Server Big Data Clusters, Hadoop, PostgreSQL, SQLite, Parquet, Spark, HBase, HDFS, Kafka, Zookeeper, NoSQL, Yarn, Elastic Search, Hive, Jupityr Notebooks, Zeppelin Notebooks, R, etc.). The successful candidate will be assigned software development tasks in support of data analytics tasks. Other duties include: documenting, managing configuration, testing, and bug fixing involved in creating and maintaining applications and frameworks involved within an agile software release life cycle and resulting in a software product. The successful candidate will be expected to utilize BD and KM tools and follow processes that ensure high quality software is delivered. Candidates must also possess significant experience writing, executing, creating both database queries and Python scripts. Software Engineers of all seniority levels are encouraged to apply and will be considered. Candidates must be self-motivated and capable of working independently with little supervision / direct tasking. Candidates must be comfortable working with a wide range of stakeholders and functional teams at various levels of experience physically located in every time zone nationwide, have excellent communication skills and be comfortable providing support to assist customers with installation and configuration of CHEETAS and the underlying ecosystems CHEETAS requires to function. This position is anticipated to require significant travel (2-3 weeks per month) based on workload to support end users located at various DoD Ranges across the CONUS and potentially Hawaii. Come join the CHEETAS team and be a part of the award-winning team responsible for revolutionizing how data analysis is performed across the entire Department of Defense!
Must be a U.S. Citizen with an active or Current Security clearance - Top Secret preferred
This position requires a bachelor's degree in Computer Science or a similar field, and 13 years of experience. Advanced degrees may be substituted for years of experience on a year-for-year basis. All candidates regardless of years of experience are encouraged to apply.
Previous experience must include five (5) years of software engineering with intelligence exploitation systems or big data analytics or DoD T&E data processing.
Significant travel will be required with this position, 2-3 weeks per month working at DoD facilities with customers could be normal depending on workload.
Knowledge / Skills / Abilities:
Excellent written and verbal communications skills are desired, as the Software Engineer will be in frequent contact with end users, CHEETAS project technical lead, and be taking direction from various contract & government leads.
Proficiency using at least one high-level programming language (, C, C#, C++, Python, Bash, Java etc.)
Proficiency with web application technologies, such as JBoss, Apache Tomcat, NodeJS, etc.
Experience with developing containers and micro-services desired.
One year experience developing applications using Big Data databases (e.g., Accumulo, HBase, MongoDB, Cassandra, Hive, Elastic Search, MS SQL Server Big Data)
Experience with some of the following: Kubernetes, Docker, Helm Charts, Hadoop, Cloudera, Hortonworks, Apache Storm, Apache Spark, HBase, YARN, map-reduce, big-data analytics, semantic-web (RDF, OWL), Hive, Elastic Search, MS SQL Server Big Data and graph-databases.
Experience using Python, R scripting, and SQL.
Knowledge of software design patterns, and Agile Development methodologies.
Use of advanced Data Science techniques for Modeling and Simulation Programs a plus
Knowledge of Distributed Testing and Training a plus
Experience with a version control system (e.g., Git), issue/problem tracking system (e.g., Jira), team collaboration software (e.g., Confluence), continuous integration environments (e.g., Jenkins), cloud environment (e.g., Amazon Web Services (AWS), Microsoft Azure) and virtualization platforms (e.g., VMWare).
The Software Engineer must have the ability to work closely with other engineers to develop the best technical design and approach for new product development.
The preferred candidate will have experience working in government/defense labs and their computing restrictions and have experience with extracting, transforming, and load process for T&E data.
Knowledge of the Test and Training Enabling Architecture (TENA), the Joint Mission Environment Testing Capability (JMETC), and Distributed Testing and Training is a plus.
Experience working with major DoD Acquisition programs such as Joint Strike Fighter (JSF) or Missile Defense Agency (MDA) is a plus.
Knowledge of DoD Cybersecurity policies is a plus.
In compliance with the U.S. federal governments vaccine mandate, only candidates who are fully vaccinated for COVID-19 or have a reasonable accommodation or approved medical exception will be considered for this position.
KBR is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, disability, sex, sexual orientation, gender identity or expression, age, national origin, veteran status, genetic information, union status and/or beliefs, or any other characteristic protected by federal, state, or local law.
Based on recent jobs postings on Zippia, the average salary in the U.S. for a Database Administrator is $83,533 per year or $40 per hour. The highest paying Database Administrator jobs have a salary over $111,000 per year while the lowest paying Database Administrator jobs pay $62,000 per year
Consultants are individuals who were tapped by a company or an organization to work on a specific activity, depending on their field of expertise. They act as guides for the organization in undertaking projects that are related to their field. Consultants would usually assist organizations in planning, often giving advice when the need arises. They would, at times, take the lead in activities that involve data gathering and interpretation of data gathering results so that they can provide solid recommendations on actions that the organization may undertake. They may also guide the organization in implementing any changes brought about by their consultancy and in evaluating the effectiveness of the changes.
Administrators are administrative professionals who oversee the whole office or department. They manage office activities and supervise administrative functions in the office. They work the office calendar and oversee the appointment-setting process. They coordinate office events and ensure that all preparations are made and that there are no conflicting schedules. They also maintain a database of external providers of various office needs. Administrators also oversee office supplies and prepare purchase requisitions. They also manage janitorial services and other functions that are related to the maintenance of the physical office space. Administrators ensure that all fixtures and equipment in the office are functioning well and have no problems.
A senior programmer/analyst is responsible for developing and sustaining databases and software applications to achieve business requirements. The professional performs development duties such as coding and testing these applications. The core skills that the job requires include familiarity with applicable data privacy practices and laws, a keen eye for details, and strong analytical and problem-solving skills. Also, the job requires a college diploma or university degree in the field of computer science, information systems, or software engineering.
Managers are responsible for a specific department, function, or employee group. They oversee their assigned departments and all the employees under the department. Managers are responsible that the department they are handling is functioning well. They set the department goals and the steps they must take to achieve the goals. They are also in charge of assessing the performance of their departments and their employees. Additionally, managers are responsible for interviewing prospective candidates for department vacancies and assessing their fit to the needs of the department. Managers also set the general working environment in the department, and they are expected to ensure that their employees remain motivated.
Office managers oversee the entire workplace. They maintain office processes and services to ensure that everything is running well. They manage office supplies by managing inventory and procurement procedures. They also device filing systems, create needed and relevant office policies, and ensure that all the policies are being followed. As a way to make sure that the office is in top shape, office managers supervise most of the logistical aspects inside the office. They also provide support to both management teams and the rest of the employees. They often act as the bridge between the two and would sometimes even assist in the training of new employees.
Yes, you can make $100,000 per year as a database administrator. The chances of earning over $100k for a database administrator are actually pretty good because the highest-paid database administrator positions typically pay at least $111,000 per year. The average annual salary is $83,533 for database administrator jobs. For example, database administrators in Washington whose salaries are in the 90th percentile earn an average salary of $136,000.
Yes, database administrator is a relatively good career. The role of a database administrator (DBA) is gainful with a good job outlook, but the work can be extremely stressful without much recognition.
Yes, there is a demand for database administration. More and more, organizations are using big data to make better business decisions. Consequently, there is a growing need for technical professionals to store, organize, and troubleshoot organizational data.
The qualifications of a database administrator (DBA) are typically a technical college degree, years of related work experience, and a few technical and soft skills.
The first qualification of a database administrator is a technical college degree. Most DBAs have bachelor's or master's degrees, with most holding bachelor's degrees in management information systems (MIS).