You will perform work for all aspects of database administration - design, documentation, implementation, maintenance, scripting, coding, backup/recovery, security, and integrity.
This position requires good technical, customer service, and organizational skills to support Systems Development and Systems Infrastructure.
Also, the ability to function successfully in both team and independent work environments.
Essentially, will keep databases up and running smoothly 24/7 with a goal of providing seamless flow of information throughout the organization
Essential Duties and Responsibilities
Design, install, document, manage and maintain staging, test and production databases for maximum performance, scalability, flexibility, and reliability
Review and approve all proposed changes to database schema, tables, stored procedures, user-defined functions, SSRS reports, etc.
Analyze and recommend database improvements
Evaluate and recommend new database technologies
Collect data in order to evaluate and optimize DBMS performance
Monitor system resource utilization and trending for future capacity planning
Install, test and maintain DBMS and application software including patches, fixes and version upgrades
Develop, manage and test database and information system backup and recovery plans
Design and implement processes and procedures to reduce and eliminate database outages and downtime
Monitor and support availability groups and failover configurations
Monitor and support transactional replication
Design, implement and maintain database security strategies that provide the appropriate level of security for users and applications
Ensure appropriate security and privacy measures are implemented on technology solutions to protect company data from intentional or accidental misuse
Manage and audit database permissions and access
Implement and maintain database security and encryption
Analyze query plans and tune application performance by optimizing SQL code
Monitor database logs for hardware, memory or disk space/capacity issues and take appropriate action
Review and implement database parameter and configuration changes for optimal performance with the host operating system
Develop and maintain scripts to automate SQL administration tasks
Establish and enforce rules, standards and policies for overall use of databases to ensure compliance
Recommend procedure modifications or improvements
Responsible for instance planning
Stay current on the latest technology trends and innovation to provide insight into strategic and tactical decisions as needed
Qualifications:
Qualifications
Oracle, Microsoft
Cloud experience
Data Warehouse experience
BS in Information Technology, Information Systems, Database Management, Computer Science, or related field (relevant experience and education may be considered in lieu of degree)
