What are the responsibilities and job description for the Database Administrator position at ONTELLUS?
JOB SUMMARY
The Database Administrator will provide technical and functional support for Ontellus installations of databases including, but not limited to, Microsoft SQL Server (MSSQL) 2008 and above. Position will also assist in the managing of the design, configuration, implementation, and maintenance of MSSQL databases, application design and implementation, performance tuning, data migration, and other areas of database administration.
JOB RESPONSIBILITIES
Responsible for primary support of third party systems including
- DBA support of production, test and development environments and reporting
- processes.
- Administer lead activity for database security, database backups/recovery
- and perform database monitoring, analysis and optimization of all database
- Environments.
- Assist end user/s with reporting requirements, documentation for queries,
- reporting and database design.
- Develop and document technical specifications for third party systems
- implementation and reporting.
- Design, plan and implement assigned database environments.
- Properly size and configure databases and their associated tables.
- Provide production support in a 24/ 7 environment.
- Coordinate, administer, and perform installation, configuration, troubleshooting and maintenance of assigned database environments.
- Create and maintain database standards, policies and procedures, change management standards and policies and ensuring consistency between these and the environments. Formulate recommendation improvements in these areas.
- Responsible for the implementation and support of security measures and products, including activities such as database hardening, vulnerability assessment and patch management.
- Assist in the troubleshooting and resolution of complicated issues within the applications, software/hardware in database environments.
- Evaluate, recommend, and use software tools to monitor and manage database health and performance.
- Plan, coordinate, configure and implement assigned database application patches and upgrades.
- Define and maintain capacity plans, disaster recovery plans and facilities for the database environments.
- Train and mentor other team members through knowledge transfer. Monitor database environments for proper operation within established performance and availability expectations.
- Work with technical analyst to properly size and configure servers for databases and application servers.
- Responsible for advanced configuration of database environments for database level backup/restore technologies and troubleshooting configuration problems.
- Maintain current knowledge of trends and future direction in technology as it relates to area of responsibility.
- Assist with justifications for operating and capital budgets. Prepare and present technical reports and feasibility studies.
- Develop strategic technical implementation plans and work plans for technical teams.
- Regular time and attendance.
- Other duties as assigned.
- At least 5 years experience as a database administrator in a production environment is required.
- Disaster Recovery/ Business Continuity plans and implementation experience using a remote environment is required.
- Previous experience working in a team environment is required.
- Bachelor’s degree from an accredited institution in Computer Science or related area is required, OR significant work-related experience in all job requirements for this position may be considered in lieu of degree requirement.
- Computer skills required: MS SQL 2008 , SSRS, SSIS, VSDT
- Proficient with Microsoft Office Suite to include Word, Excel, and Outlook
- Outstanding organizational and time management skills
- Excellent communication skills and the ability to communicate with tact and diplomacy
- Attention to detail and the ability to concentrate for extended periods of time.
- Excellent time and attendance
- Ability to work in a team environment
- Self-motivation