IT Database Administrator Senior

Overview This Work Matters… Are you a collaborative database administrator with an agile-focused approach to development? Do you have advanced experience in MS SQL Server Management Studio and Visual Studio, who designs complex systems with automation in mind? Are you ready to make an impact in your community? Multnomah County is looking for an IT Senior Database Administrator to be responsible for the design, development, tuning, maintenance and administrative of Enterprise SQL Server database environments. In this role, your primary focus will be on Database Administration, troubleshooting, maintenance and support Administer database components (i.e., containers, tablespaces, tables, indexes, views, etc.) for on-premise as well on cloud. Administer database security, monitor and correct space utilization. Design and implement physical and logical database backups and perform database restorations. Develop and maintain OS command scripts to support a variety of database maintenance activities Develop and schedule database maintenance jobs, Troubleshoot database problems which involves analyzing the problem, identifying alternative solutions, projecting the consequences of proposed actions and implementing a solution. Develop and schedule database maintenance jobs as well as analyze and troubleshoot problems, and implement solutions. Plan and execute database object migration between development, test and production environments Ensure compliance to promotion and deployment of applications to production environments following established promotion and change control processes. Coordinate with software developers and business analysts to provide input on data conversion, integration, and defect repairs. Perform installation, upgrades, patches for supported COTS applications and database software release. Database Architecture and Development Create architectural models and evaluate architecture, technology and product alternatives. Plan, define requirements, design, develop, and maintain logical and physical data models for complex decision support and transaction processing systems. Develop, maintain and optimize the most complex SQL statements and shared database objects across multiple DBMS platforms. Create and maintain jobs, dynamic database objects, tables, files, and indexes to support computer applications using SQL, functions, stored procedures, triggers and views. Design, build and deploy effective ETL solutions and provide maintenance, troubleshooting, support and performance improvements. Develop physical architecture for real-time data management designs and off-line repository stores. Interact with network administrators to ensure confidentiality, security, scalability, and recoverability of datadatabases. Database Performance Tuning and Standards Monitor performance, identify bottlenecks and recommend andor perform adjustments to optimize performance Automate the management of database server performance tuning and database life cycle utilizing database administration tools. Research software alternativesupgrades to improve security, performance, reliability, and recoverability of DBMS. Plan, coordinate, and perform software and database migration for software upgrades. Develop standards for metadata and interact with business analysts and application developers to ensure accuracy of metadata. Develop standards and procedures for data extraction, cleansing, and transformation to ensure statistically valid data. Project Management and Technical Assistance Collaborate with project managers and business users and assist in troubleshooting complex SQL statements and database problems Provide assistance with the installation of database client software Participate in data quality efforts and in architecture design Create or provide assistance with database models Perform manual and automated administration of web environments. Continuous Integration and Delivery Architect and design complex systems and processes to automate and script application specific build and deployment needs. Manage, plan, and coordinate system changes and deployments of those changes into support systems as needed. Develop and maintain automation scripts that are standard and reusable across applications. Administration of DevOps infrastructure and tools supporting the DevOps processes. Develop and maintain standards related to DevOps practices. Automate build, testing , and deployment tasks for custom applications, COTS applications, on-premise applications, and cloud applications. A Little About Us Multnomah County IT httpsmultco.it is one of the most innovative government IT organizations in the nation, dynamically aligning itself with emerging industry trends. We are a group of creative, smart, and talented people who foster an inclusive environment of collaboration and fun. Our strength is the diversity of our people. To Qualify We will consider any combination of relevant work experience, volunteering, education, and transferable skills as qualifying unless an item or section is labeled required. Please be clear and specific about how your background is relevant. Minimum QualificationsTransferable Skills Bachelor’s degree (in lieu of degree, equivalent years of experience will be considered) 5 years of experience in IT development and database administration Advanced knowledge and experience of RDBMS management tools, including MS SQL Server Management Studio Installing, performance tuning, maintaining, securing and administering a MS SQL Server database environment Installing, performance tuning, maintaining, securing and administering a MS Integration Server (SSIS) environment Security, authorization and authentication in Microsoft Active Directory MS SQL Server backup and recovery design and implementation Developing on a SQL Server platform using Transact SQL (T-SQL) including stored procedures, query plans, functions, views, indexes and triggers Database modeling, data conversion and ETL tools such as SSIS Basic knowledge and experience of Microsoft Windows Server Administration Administrative Scripting (C, WMI, PowerShell, Rs Utility, MSBuild) MS Windows Server high availability technologies, Application Development, architectures, languages, andor tools Developing and managing database in cloud computing environment (Microsoft Azure) DevOps and CICD activities Ability to pass a criminal history record check Screening and Evaluation The Application Packet A completed online application. A resume covering relevant experience and education. Please be sure your resume includes the following for each employer name of employer, location, dates of employment, your title, a brief summary of your responsibilities, the number of employees under your supervision. A cover letter that expands on your resume, addresses why you are interested in this position and demonstrates how your experience and skill set aligns with the minimum and preferred qualifications listed. Note The application, resume and cover letter should demonstrate your work experienceskills and how it is related to those shown in the Overview and To Qualify sections of the job announcement. Please be thorough, as these materials will be scored and determine your eligibility for an interview. The Selection Process For details about how we typically screen applications, review our overview of the selection process httpsmultco.jobsselection-process page. We expect to evaluate candidates for this recruitment as follows Initial review of minimum qualifications We may do an additional preferred review andor send out additional supplemental questions to identify those highest qualified. Evaluation of technical knowledge, skills, and abilities There is a virtual scored evaluation session with the hiring manager to review the required technical skills and knowledge for this position. Consideration of top candidates We will consider qualified candidates in order of rank and score from the list of eligible candidates. This may include panel interview(s), a hiring interview, andor additional testing to determine the best candidates for a position. Background check and reference checks All finalists must pass a thorough a criminal record check and reference check. ADDITIONAL INFORMATION This recruitment may be used to fill full-time, part-time, temporary, limited duration and on-call positions. Type of Position This hourly union represented position is eligible for overtime. Location Multnomah Building – 501 SE Hawthorne Blvd. Schedule Monday – Friday 800am – 430pm. There is some flexibility with the start and end times and a possibility of an alternative schedule after an initial orientation to the position. Diversity and Inclusion At Multnomah County, we don’t just accept difference we value it and support it to create a culture of dignity and respect for our employees. We are proud to be an Equal Opportunity Employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran or protected veteran status, genetic information and other legally protected characteristics. The EEO is the Law poster httpswww.eeoc.govsitesdefaultfilesmigratedfilesemployersposterscreenreaderoptimized.pdf is available for your reference. Multnomah County is a VEVRAA Federal Contractor. We request priority protected veteran referrals. Veteransrsquo Preference Under Oregon Law, qualifying veterans may apply for veteransrsquo preference. Review our veteransrsquo preference page httpsmultco.jobsveterans-preference-information-and-instructions for details about eligibility and how to apply. Accommodation under the Americans with Disabilities Act We gladly provide reasonable accommodation to anyone whose specific disability prevents them from completing an application or participating in this recruitment process. Please contact the recruiter below in advance to request assistance. Individuals with hearing or speech impairments may contact the recruiter through the Telecommunications Relay Service by dialing 711.

The post IT Database Administrator Senior first appeared on Oregon Job Market.

from Oregon Job Market https://ift.tt/2PjZd0H
via IFTTT