Description
Job Description
Our client is seeking logical Database Administrator (DBA) to work on an application development project across the Division's of our client's.
Job Summary:
- Works with our client's staff to significantly improve the application of technology across the client.
- Assists in database design, process re-engineering, application development and the application of technology to significantly improve quality and efficiency in support of our client's operations.
- Works closely with application development team members on the design, development, and implementation of a wide array of client- and/or web-based systems in support of current and future business processes; assesses reporting needs and builds and supports appropriate databases to facilitate effective use of data.
- Designs and secures computer databases to store, track, and maintain a large volume of critical business information.
- Develops database models, definitions and standards for administering databases.
- Makes recommendations for the migration of Legacy databases to modern database environments, and implements as directed.
- Facilitates application and user access to data for input and output.
- Administers existing databases for applications.
- Works with our client's business and technology staff and application developers to facilitate successful outcomes.
Job Responsibilities & Performance Standards:
- Able to perform job responsibilities with minimal supervision. Serves as a logical DBA, and interacts with third party providers of physical DBA role.
- Analyzes database problems and implements solutions within a reasonable timeframe. Reviews database for unexpected conditions as required.
- Develops ad-hoc queries to meet agency business requirements and to monitor potential or actual database integrity problems according to industry standards.
- Interacts with third party providers to ensure database recoverability.
- Ensures that back-ups of database structure and data are performed on a regular basis.
- DBA responsibilities require collaboration with third-party service providers.
- Serves as job expert or organization resource in assigned areas.
- Reviews requirements and gathers additional database object information from requestors as needed.
- Accurately and effectively uses database related catalog management tools to create database object definitions.
- Correctly creates or alters database objects.
- Administers appropriate security by coordinating access privileges for development staff and user personnel for database objects.
- Appropriately produces logical database designs, relative to systems development, implementation and troubleshooting as needed.
- Informs customers and programmers of testing processes and adequately discusses final products with pertinent parties before systems are fully implemented.
- Produces data models within project schedule using appropriate techniques.
- DBA responsibilities may require collaboration with third-party service providers.
- Develops and enforces utilization of object naming standards according to established guidelines.
- Effectively uses presentation skills when delivering and explaining data models enabling recipients to understand and use the models.
- Informs customers and programmers of testing processes and adequately discusses final products with pertinent parties before systems are fully implemented.
- Supports the installation and testing of new products and improvements.
- Plans production data migrations with appropriate personnel to ensure effective implementation.
- Produces detailed migration plan following required change control process.
- Some responsibilities may require collaboration with third-party service providers.
- Designs and modifies table structure, queries, automated data entry processes, and reports. Provides guidance and recommendations involving program modifications or upgrades that interface with database software as needed.
- Assists support personnel in establishing database parameters.
- Reviews and makes recommendations regarding database emergency disaster recovery readiness.
- Assists in developing interface requirements needed to utilize the database system and support tools when required.
- Carefully evaluates and makes timely recommendations on upgrades for database and products which use database.
- Participates in the preparation and presentation of training materials that provide appropriate educational instruction in the use and capabilities of database systems and related software tools.
- Ensures timely identification and resolution of database related software and hardware problems.
- Works with vendor and technical support personnel in producing documentation and other required problem-solving information in a timely manner.
- Some responsibilities may require collaboration with third-party service providers.
- Reviews the protection of vulnerable information.
- Reviews and analyzes proposed hardware and network changes which may affect database performance.
- Determines impact of changes and makes appropriate recommendations.
- Communicates impact of changes on database with appropriate personnel.
- Works to ensure that disruption of database services is minimized.
- Implements measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
- Advises and assists programmers in coding and testing database requirements for programs according to established guidelines.
- Reviews programmers written database access language for efficiency and correctness. Obtains clarification from appropriate personnel when objectives of coded language are unclear.
- Answers questions and assists developers in a timely manner.
- Appropriately assists other staff members with complex queries and with analyzing queries for efficient database access.
- Sets up and manages scheduling of updates and reports
- Prepares standard query language (SQL) statements for use in programs as needed by programming staff.
- Obtains feedback as necessary to ensure accuracy of finished product.
- Tests code thoroughly as needed to ensure efficient and accurate results.
- Sets up processes for offloading data to external applications.
- Translates complex or technical information into a format that can be understood by others and distributed as needed.
- Incorporates knowledge of pertinent new trends and developments into procedures and makes recommendations for any related changes.
- Recommends Specifies access levels for each segment of the database.
- Communicates regularly with agency and third-party staff on progress toward defined goals and/or required results.
- Confers regularly with others to review specific problem areas and actions necessary for improvement.
- Tests programs or databases, corrects errors, and makes necessary modifications.
- Treats customers with respect, courtesy and tact; listens to customer and interacts with customer as a person while maintaining a business relationship.
- Communicates with customers and obtains all required information necessary to determine and address their specific needs.
- Provides clear, accurate information; explains procedures or materials or provides supplemental information; anticipates problems and questions.
Technical Competencies:
- Experience working in information management, with emphasis on database administration, SDLC, systems integration, complex SQL queries, relational database concepts, data warehousing, data modeling, Business Intelligence and reporting solutions
- Planning and design of database functions and applications integrating existing and future systems
- Ability to research and design queries and reports; convert existing reports; develop new custom reports and interfaces
- Strong problem solving and analytical skills; ability to analyze user problems and recommend alternatives or solutions; ability to understand and communicate technical issues in a non-technical manner
- Experience in multiple technology environments including MS SQL, MySQL, Visual Basic, Microsoft Access, FoxPro, .Net, ASP, VBScript, Javascript, MS Office; experience with ESRI ArcGIS Server is a plus, strong background in Microsoft Access is preferred.
- Strong organizational, multi-tasking, and time-management skills; the ability to plan and organize multiple projects and meet deadlines
- database administration such as data model design and maintenance, DDL (data definition language) generation, SQL writing and tuning, coding stored procedures, collaborating with developers to help choose the most appropriate DBMS feature/functionality and other pre-production activities.