Lavoro Microsoft-sql-server a distanza a detroit ∙ Pagina 1

About the Department

This is not a Civil Service Position.  DWSD employees are subject to provisions of Court Orders entered in United States District Court, Eastern District of Michigan, Southern Division, Case No. 77-71100 with regard to certain terms and conditions of employment. DWSD does not honor reversion rights for internal candidates. 

Applicants for open positions at the Detroit Water and Sewerage Department must be authorized to work for ANY employer in the U.S. The Detroit Water and Sewerage Department is unable to sponsor or take over sponsorship of an employment Visa at this time. 

SUMMARY: 

The Database Administrator operates under limited supervision and manages performance, integrity and security of DWSD enterprise databases.   Designs, implements, and maintains databases with respect to access time, access methods, device allocation, validation checks, organization, protection and security, documentation, guidelines, and statistical methods.

ESSENTIAL JOB FUNCTIONS:

Lead database design to support user/business needs, application development and implementation efforts, and the project team.  Provide direction to solutions involving database activities including physical structure, functional capabilities, security, and back-up/recovery specifications. Provide maintenance of database dictionaries, the overall monitoring of standards and procedures, and the integration of systems through the database design process. Consult, coordinate, and communicate with business units and IT staff providing solutions and recommendations which integrate with current and future database, application, and infrastructure architectures. 

Design, test, implement, monitor and maintain Oracle and Microsoft SQL Server database systems to meet organizational availability and security requirements. Code and implement database definitions and descriptions; develop and administer database utility routines for verifying the validity of data element values, optimizing performance, backing up and recovering data sources and maintaining the integrity of the organization’s database systems. Provide database requirements, design, installation, support and problem resolution. Maintain and monitor performance, capacity, and availability of organization-wide databases. 

Provide technical documentation, expertise, training, and consulting related to database creation, maintenance, and uses. Manage database software licensing and database management projects. Responsible for defining technical database design and implementation approaches for IT projects.  A valid Michigan Driver’s License and the ability to drive a motor vehicle on all terrain.  Follow security and safety policies and procedures in carrying out work duties.   Provide on the job training. 

RELATED JOB FUNCTIONS:

Assist other IT staff and IT management as needed with overflow activities involving the support and maintenance of computers, printers, applications, databases, networks, servers, storage, and data center facilities, and the installation, decommissioning, and relocation of related IT equipment.   Perform related work duties as assigned. 

Position Duties

REQUIRED KNOWLEDGE, SKILLS AND ABILITIES 

KNOWLEDGE OF:
•Enterprise database performance, integrity, and security 
•Principles and practices of the functions performed by IT Services
•Oracle and SQL Server relational database management system
•Concepts, practices and procedures (COBIT and ITIL), including Change Management, Software/Systems Development Life Cycle for IT systems development and management
•Hardware, software, application, database and network environments currently in use at DWSD
•Principles and techniques of database and application development and languages in use at DWSD
•Principles and techniques of systems analysis, design and development lifecycle
•Installation and maintenance of application and database components 
•Water and wastewater business functions and operations

SKILL TO:
•Install, remove, and make modifications to technology
•Apply IT policies and programs in a manner aligned with the DWSD mission, goals, and strategies
•Independently, and as part of a team providing timely, high quality customer-focused services 
•Work in a busy environment, with frequent interruptions and still be able to prioritize and resolve conflicting requests
•Work in a professional manner with access to confidential and other data types
•Exercise Enterprise management skills 
•Exercise good judgment, discretion, maintains confidentiality, and work with independence, initiative and professionalism
•Work in a team environment that provides the capacity for IT project delivery
•Resolve technology and user issues both verbally and in writing to end-users of varying computing skills
•Deliver quality written documentation and presentations, including the ability to make technology understandable to end-users
•Understand and translate the needs of varied users into IT system requirements
•Use advanced technology

ABILITY TO:
•Work independently, and as part of a team providing timely, high quality customer-focused services 
•Demonstrate critical thinking ability
•Work in a team environment that provides the capacity for IT project and service delivery
•Organize, perform and or coordinate technology tasks and projects
•Define appropriate technical approaches and solutions to projects and business initiatives 
•Determine critical project criteria to ensure project completion
•Perform database administration on multiple enterprise application databases
•Instruct groups or individuals on technology
•Deliver quality customer service to users
•Write technical and non-technical documentation
•Interact and communicate with IT staff and business users
•Apply IT policies and programs in a manner aligned with the Department mission, goals, and strategies
•Learn new application software packages, operating systems, and IT processes and procedures
•Effectively utilize appropriate safety equipment and procedures
•Communicate effectively, both verbally and in writing
•Understand and follow verbal and written instructions  
•Establish and maintain effective working relationships with others
•Communicate frequently with the team members and other units across the Department about process, equipment or potential problems
•Direct team activities or to work as a team member
•Demonstrate leadership skills and mastery of IT principles and procedures
•Consult, coordinate, and communicate with business units and IT staff providing solutions and recommendations which integrate with current and future database, application, and infrastructure architectures
•Design, test, implement, monitor and maintain Oracle and Microsoft SQL Server database systems to meet organizational availability and security requirements
•Code and implement database definitions and descriptions; develop and administer database utility routines for verifying the validity of data element values, optimizing performance, backing up and recovering data sources and maintaining the integrity of the organization’s database systems
•Responsible for capacity planning and management, security planning and management, data management, systems maintenance, and performance management of one or more systems
•Provide database requirements, design, installation, support and problem resolution 
•Maintain and monitor performance, capacity, and availability of organization-wide databases 
•Provide technical documentation, expertise, training, and consulting related to database creation, maintenance, and uses
•Provide technical support resolving incidents, including creating, and closing tickets
•Manage database software licensing and database management projects
•Plan, design, and implement IT-related policies and procedures
•Document system problems and resolutions for future reference
•Define technical database design and implementation approaches for IT projects
•Provide technical expertise, consulting, and training related to database development and management
•Follow security and safety policies and procedures in carrying out work duties
•Provide on the job training
•Perform related work duties as assigned
•Manage database systems installations and configuration
•Perform backups, restores and non-production Database data refreshes
•Implement systems changes in support of performance optimization
•Perform database maintenance (table reorganizations, database compaction and generate index statistics)
•Develop and maintain database disaster recovery processes
•Complete Data model design and maintenance
•Generate DDL (data definition language) 
•Generate SQL writing and tuning
•Complete coding stored procedures
•Collaborating with developers to help choose the most appropriate DBMS feature/functionality and other pre-production activities
•Manage all the application components that interact with the database
•Application installation and patching and upgrades
•Building and running data cleanup routines and data load process management
•Act as one of the foremost technical authorities in the area of database administration
•Lead all aspects (which may include other IT disciplines) of database management projects
•Plan, design and implement additions, upgrades, replacements, or retirement of database management systems
•Responsible for performance, integrity, and security of databases
•Execution of planning, coordinating and directing workflow, operations, and employees to create an environment that enables efficient and productive work.

Minimum Qualifications

REQUIRED EDUCATION AND EXPERIENCE (position requirements at entry)

• A minimum of five (5) years of related work experience
• Master’s Degree preferred

ESSENTIAL REQUIREMENTS

Physical Requirements:  

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential duties of this job.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential duties.

This position requires physical ability to climb, balance, stoop, kneel, crouch, crawl, reach, stand, walk, push, pull, lift, finger, grasp, feel, talk, hear see, and perform repetitive motions.  Essential duties require the mental and/or physical ability to work in a standard office environment; read fine print on blueprints and display terminals; converse by telephone, two-way radio and in person using writing instruments, calculators, and personal computers; and strength to lift and carry up to 40 pounds.  The work requires the ability to distinguish colors and to hear audible alarms.  Incumbents may be subject to potentially hazardous physical conditions, atmospheric conditions, extreme temperatures, intense noise, and/or vehicle traffic.  Employees will also be required to pass a bio-mechanical physical.

Environmental Working Requirements: 

Work is performed within an office, plant environment, remote sites, or other locations within the DWSD Service Area. Employees within this classification may be exposed to dust and electrical connections, and frequent work with computer equipment.   

OTHER REQUIREMENTS

Must have a valid Michigan Driver’s License

Ability to work irregular hours, to commute to DWSD facilities and work sites, and respond to after hour emergencies and on-call responses.

The above statements describe the general nature and level of work performed by employees assigned to the class. Incumbents may be required to perform job-related responsibilities and tasks other than those stated in this specification. Specific job duties may vary from position to position. Employees in this class are required to undergo alcohol and drug screening and are subject to a criminal background investigation.