The Database Systems Consultant is a technical position involving the support of database software packages, and other data modeling software tools. This incumbent will aid in the support of several company databases. This incumbent has intermediate experience with database administration, data modeling techniques and database monitoring tools. This incumbent will be responsible for handling much of the companies database administrative functions. Incumbents will be supporting databases that house critical data of third party tools or applications i.e. SAP, Websphere, AutoSys, Informatica.
Primary Responsibilities:
- Will be required to support non-mission critival systems (test, development) with little support or assistance. May be required to support enterprise-wide, mission-critical databases. Ensure sound physical data models to support application requirements with minimal assistance
- Monitor database schema performance and storage management to ensure optimal application performance. Involved with the installation, implementation and configuration of company databases. Will be required to participate in 24*7 on call support of company databases.
- Work closely with the operating system and application administrative personnel to ensure space requirements, backup procedures and performance needs are being met. Will participate in the analysis and design function for new and existing systems to ensure adherence to technical standards, data standards and integration with other applications.
- Will work across functional support areas to tune databases for optimal performance. Troubleshoot intermediate problems and recommend appropriate actions.
- Analyze and participate in the security and data integrity controls for all of the computerized database resources. May be involved with the planning, design and implementation of databases on a variety of platforms. May participate in the implementation of systems and application software.
Job Qualifications:
- Bachelor's Degree in computer science, MIS, engineering or related discipline.
- 6 years of experience in Information Technology
- 5 years of experience in database systems (SQL Server) is required.
- Has experience with PowerShell Scripting and T/SQL.
Knowledge, Skills, Abilities:
- Advanced knowledge of operating systems, client/server architectures and standards.
- Advanced knowledge of all currently used database applications.
- Good knowledge of data modeling, logical and physical database design and implementation.
- Good understanding of middleware standards, networking technology and protocols.
- Good troubleshooting skills.
