OlympiaRecruiter Since 2001
the smart solution for Olympia jobs

Database Developer

Company: State of Washington
Location: Olympia
Posted on: June 10, 2021

Job Description:

The Department of Children, Youth, and Families (DCYF) was created to be a comprehensive agency exclusively dedicated to the social, emotional, and physical well-being of children, youth, and families regardless of race, ethnicity, sexual orientation, or other socioeconomic factors. We believe our workforce should reflect the communities we serve and are actively searching for candidates that reflect that diversity. We're looking for two experienced Security/Database Developers to implement and maintain security controls for DCYFs mission-critical databases, data interfaces, and systems. These systems carry highly sensitive information and have a direct impact on the work that is performed by business units. These business units are all working toward the common goal of eliminating child and youth outcome disparities based on race and ethnicity and transforming lives by protecting vulnerable children and promoting healthier families. Our vision is that "All Washington's children and youth grow up safe and healthy-thriving physically, emotionally, and educationally, nurtured by family and community." The Opportunity: Do you have experience with database development? Does ensuring the security and confidentiality of interfaces, data, and related standards, processes, and procedures sound exhilarating? If so, consider these incredible Security Database Developer positions. These journey-level positions uses in-depth and advanced knowledge of databases needed to maintain operations, participate in development projects, migration projects, and perform problem resolution activities involving the most complex technical issues. These positions ensure the confidentiality, availability, integrity, and quality of data in DCYF's mission-critical database systems. Another key objective of these positions is to serve as a Data Custodian for DCYF data, exercising significant influence over data quality processes, procedures, and data governance. Not only will you get to work on a fantastic team in a flexible work environment, but you can also feel good knowing that your work contributes to positive outcomes for the children, youth, and families of Washington State. We are currently teleworking due to the Stay Home, Stay Healthy order. This position has the potential to continue teleworking once it is lifted but will be required to attend some be meetings and training in-person. Some of what you will get to do: Ensure the security and confidentiality of DCYF interfaces, data, and related standards, processes, and procedures.Perform and monitor automated security scanning of DCYF databases. Collaborate with the Information Security Office on results, and progress or mitigations.Maintain database security for DCYF's multi-SOL server database environment (multiple versions of Microsoft Server from 2008 to current) which supports statewide, mission-critical, client-server, and .NET database systems, SQL Reporting services platforms, SQL Data Warehouses, and cloud-based databases and repositories.Develop, maintain, implement, test, and configure DCYF data resources.Exercise database disaster recovery plans.Provide consultation to senior management to ensure the effective use of existing and emerging database security technologies.Analyze and document security problems.Work with application developers and DevOps to ensure regular, secure, controlled deployment of updates to existing database-driven applications across various platforms including but not limited to the development, QA, and production environments - including cloud-based resources.Perform development and maintenance tasks for mission-critical databases.Troubleshoot and resolve complex database interface and data-related issues.Perform database utility functions.Develop, maintain, and implement database security plans, ensuring compliance with security and privacy requirements.Design and implement mitigation and remediation strategies to address vulnerabilities found by automated security scanning of DCYF databases.Maintain an expert-level understanding of security rules and configurations.Participate in peer reviews and inspections.Research and prototype new upgrades and technology to improve database security and functionality. Required Education/Experience: A Bachelor's degree or higher in computer science, data management, information systems, or closely related field, or five years of progressively more complex problem-solving experience as a Database Administrator or Database Developer of large-scale databases with mission-critical business functions. PLUS Four years of progressively more complex problem-solving experience as a Database Administrator, Database Administrator, or Database Developer of large-scale databases with mission-critical business functions. Required Competencies: Expert knowledge of relational database development techniques and security best practices for Microsoft SQL Server including installation, profiling, monitoring and optimizing.Expert knowledge of database vulnerability scanning tools.Expert knowledge of SQL server configuration including security, logging, encryption settings.Excellent written and verbal communication skills.Experience working in a highly regulated environment where IT assets and. data are subject to a broad range of State and federal information security requirements and regulations.Expert knowledge of backup and recovery procedures.Expert knowledge of Microsoft operating systems and database platforms (Windows 10, Windows Server, SQL 2008-2017).Expert knowledge of Microsoft's implementation of SQL, specifically Transact-SQL.Expert knowledge of Database management concepts, principles, and methods including database logical and physical design, normalization, storage capacity management.Working knowledge of sources, characteristics, and uses of the organization's data assets.Working knowledge of the vast array of relationships between data entities that represent the DCYF business domain.Working knowledge of Data Warehousing principles and best practices.Working knowledge of Cloud-based data repositories, including configuration and security settings.Working knowledge of the characteristics of physical and virtual data storage media.Expert knowledge of data administration and data standardization policies and standards.Expert skill in applying data modeling methodologies to the creation and maintenance of large, complex, mission-critical database systems.Expert skill in analyzing data management systems, operating systems, technical architecture, and network topology to plan, develop and implement creative solutions to complex issues.Ability to examine complex systems to grasp issues, draw conclusions, and solve problems.Ability to adapt to continually changing business needs.Ability to assess and iteratively improve products, processes, and practices.Keeps up on the changes and improvements to operating systems, databases, and technical tools.Able to build and maintain customer satisfaction with the products and services offered by the organization.Ability to maintain the confidentiality of information accessed or discussed in performng the work of this position.Ability to convey professionalism, cultural competency and interact effectively with individuals, groups, peers, supervisors, managers, vendors, and customers in individual and group situations.Able to earn trust and respect through consistent honest and professional interactions in working relationships with others.Create a variety of technical and non-technical documents such as standards, installation instructions, operations manuals, presentations, system diagrams, status reports, incident reports, etc.Proficient in MS Office products (Outlook, Word, Excel, PowerPoint, Visio, SharePoint). In addition to those requirements, our ideal applicant will also have some or all of the following: Security CertificationsThorough understanding of Relational Database Management Systems (RDBMS)SQL certification or knowledge of SQL Server TSQLAgile Training or Certification How do I apply? Complete your applicant profile and attach the following documents:Letter of interest describing how you meet the specific qualifications for this position Current resume detailing experience and education To take advantage of Veteran's preference please attach your DD-214, member 4 long-form, or your NGB-22. Please black out your social security number prior to attaching.Supplemental Information: Prior to a new hire, a background check including criminal history will be conducted. Information from the background check will not necessarily preclude employment but will be considered in determining the applicant's suitability and competence to perform in the position. This position is covered by a collective bargaining agreement.This announcement will be used to fill multiple vacancies. The initial screening will be based on the content and completeness of your application and the materials submitted. All information may be verified and documentation may be required. Applications with comments such as "see attachments" or "N/A" in the supplemental question responses will be considered incomplete. DCYF is an equal opportunity employer and supports equity, diversity, inclusion and respect. Need accommodation throughout the application/interview process? Unable to apply on-line? Contact the Recruitment team at or (360) ###-#### or the Telecommunications Device for the Deaf at 800-###-#### Experiencing technical difficulties creating, accessing or completing your application? Call NEOGOV toll-free at (855)###-#### or email . General suggestions for creating a good application packet:Read the job posting very carefully. Find out as much as you can about the position. Make sure you are very diligent in following all the application instructions. Include all requested documentation. Make sure your application and supplemental question responses address how you meet each of the required and desired qualifications. Carefully read each of the supplemental questions and respond completely to each one. Pay careful attention to each component of the question, providing examples, and thoroughly describing when and where you achieved the proficiency level, and detail the types of work you performed, the work products, etc., to demonstrate 'how'. Specifically include all of your work experiences doing the same or similar work, especially if you reference work in these jobs in describing when/where you gained proficiency level skills. Make sure your application reflects your best writing. 01156 #ITjobs #developer #devops #employerofchoice #hotjobs #statejob Associated topics: data administrator, data analyst, data engineer, data integration, data integrity, data manager, data scientist, data warehouse, mongo database, sybase

Keywords: State of Washington, Olympia , Database Developer, Other , Olympia, Washington

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Washington jobs by following @recnetWA on Twitter!

Olympia RSS job feeds