SUMMARY: Under minimal direction, the Senior DBA will maintain and support Oracle databases and Oracle applica-tions, including production support, application patching, and bug/data fixes. DBA will develop and customize Oracle applications utilizing PL/SQL, Java, Oracle Forms and Reports. Will be involved in all phases of the Software Devel-opment Lifecycle. Design and create primary database storage structures and primary objects and modify database structure for performance and scalability. Monitor and optimize performance of the database, plan for backup and re-covery of the database, allocate system storage and plan future storage necessities. Research, evaluate, design, test, recommend and plan implementation of new or improved database tools. Conduct database administration for Oracle RDBMS utilizing Oracle database performance tuning tools, PL/SQL, SQL and shell scripting.
INITIAL PROJECTS: The senior database administrator will have a key new exciting role in planning, testing, deploy-ing, monitoring, and supporting a large Meter Data Management System (MDMS). The MDMS is a crucial component of the Smart Meter Fort Collins program currently underway in the City of Fort Collins Utilities organization. This new, mission critical database application is being procured under a Department of Energy (DOE) Smart Grid Investment Grant. The Senior DBA will additionally be involved in testing, deploying and administering database software required for the Automated Meter Infrastructure (AMI). The MDMS and AMI systems will be critical to the on-going collection of customer consumption data for both water and electric utilities. The systems will collect frequent interval meter reads on a daily basis. Ultimately, these database systems will enable consumers of the Utilities services to make informed choices as to their own usage of the resources. Initial implementation and the on-going support and maintenance of these significant additions to the City's suite of applications will require a full-time, experienced, skilled Database Ad-ministrator who has at least 5 years of direct experience working with similar mission critical Enterprise database man-agement systems.
ESSENTIAL DUTIES AND
RESPONSIBILITIES: The following duties and responsibilities are illustrative of the primary functions of this position and are not intended to be all inclusive.
Provide technical and organizational leadership in the oversight, development and implementation of the City's database infrastructure while working closely with other IT-related City staff.
Implement and maintain Oracle and Microsoft SQL Server databases through the complete lifecycle of a database, including: testing, installation, monitoring, upgrading, tuning, backup, recovery, troubleshooting, design modification and migration, as well as user, developer and application support.
Regularly perform or direct database administration duties in a multi-tiered, multiple operating system environment. Duties include database capacity management and resource optimization activities, databases design, installing and upgrading database and application middle-tier software, testing, tuning database applications, and maintaining database space allocations.
Regularly perform database systems management duties that include database installation, upgrades, patch implementation, configuration, and access security management, proactive monitoring and reporting, troubleshooting, and develop database control scripts and specialized software (APIs) to assist in the management of transaction processing environment.
Work closely with other IT-related City staff and Business Analysts to coordinate the activities of database design, programming, upgrades, patches, data migration, and troubleshooting when required.
Insure the integrity, recovery, and availability of the database environment through standard data backup and recovery strategies and lead the execution of database disaster recovery test scenarios.
Develop and maintain a methodology for the ongoing assessment of database performance and the identification of problem areas.
Diagnose and resolve database and application issues to correct errors and provide improved performance or functionality. Develop impact studies and alternative analysis for system changes; analyze performance indicators in operations.
Analyze computer systems and their components, workflow, and resource limitations to determine impacts, risks, scope, and cost estimates of requested changes, providing recommendations to management and other City staff.
Serve as backup for other databases and systems which support the City's enterprise applications, including CIS, ERP, GIS, Web, and Document Management, among others.
QUALIFICATIONS: The requirements listed below are representative of the knowledge, skills, and/or abilities required to perform the necessary functions of this position.
KNOWLEDGE, SKILLS, AND ABILITIES:
Thorough knowledge and experience with a broad range of information technologies including multi-tiered client-server computing environments, business requirements modeling techniques, web technologies, imaging, operating systems, application programming interfaces, relational database systems, and software development tools.
Thorough knowledge of Oracle 10g/11i database management systems techniques, tools, and accepted database management processes including backup, recovery, monitoring, tuning, performance management, and capacity management.
Proficient in the use of MS Windows applications, as well as experience in the use of applications such as TOAD, Visio, and Oracle Enterprise Manager.
Thorough knowledge and experience with advanced programming techniques, programming languages, and server operating systems used by the City, including SQL PL/SQL, Linux, and Windows Server.
Considerable to thorough knowledge of Microsoft SQL-Server database management techniques, tools, and accepted database management processes.
Considerable to thorough knowledge of IT development and support procedures, methods, and practices.
Considerable to thorough knowledge and experience with current information systems and software development models including Structured Analysis, Prototyping and Rapid Application Development, and Object Oriented Analysis and Design.
Considerable knowledge using the systems develop-ment life cycle to document and implement small or large projects.
Considerable knowledge and experience with the princi-ples and technologies of business systems analysis and design.
Considerable knowledge and experience in require-ments gathering techniques and tools (use case, flow charts and business process flow diagrams).
Considerable knowledge and experience in data model-ing techniques.
Considerable knowledge and experience with project management methods and techniques including work breakdown structure, estimating, scheduling, resource balancing, and the use of common project management software tools.
Ability to provide technical direction, mentoring, problem solving assistance, and database-related training to IT-related staff.
Ability to approve, schedule, plan, and supervise the installation and testing of new products and improvements to applications such as the installation of new databases or modifications to existing applications.
Ability to program, configure, manage, tune performance, and maintain the operation of complex relational databases.
Ability to proactively monitor, maintain, and upgrade the development, test, and production database and middle-tier application server environment.
Ability to interpret data models and to develop database structures.
Ability to use standard diagramming techniques to design and develop application data models.
Ability to develop and manipulate large, complex data sets.
Ability to perform advanced software program debugging, data analysis, and system analysis.
Ability to recognize, analyze, and provide solutions to difficult information technology problems.
Ability to partner with cross-functional and technical team members to successfully implement large, complex information systems and technology projects.
Ability to train users and other IT-related staff on applications in formal or informal settings.
Ability to establish and maintain effective working relationships with City staff, organizations, and the public.
EDUCATION and/or EXPERIENCE: Bachelor's degree in computer science, CIS, or related field from an accredited college or university plus a minimum of five years of direct responsibility for mission critical database systems; or equivalent combination of education and experience. Master's degree in computer science, CIS or related field is desirable. Experience with ESRI SDE is desired.
TO APPLY: Please visit www.fcgov.com/jobs to complete a City application and submit a current resume online by February 7, 2011. Requisition #11000. Post-offer background check and drug test required. EOE.
