Preferred position location: United Kingdom. Other locations to be determined by home country of successful candidate in a jurisdiction (US state or country) where WVI is registered to operate.
*Please submit your CV in English.
PURPOSE OF THE POSITION:
The Database Administrator II role usually supports multiple databases of medium to high complexity (complexity defined by database size, technology used, and system feeds and interfaces) with multiple concurrent users, ensuring control, integrity and accessibility of the data. They work on multiple projects as a team member or sometimes as a technical lead.
Individuals within the Database Administration job family design, install, maintain and upgrade the enterprise’s databases (development, testing, and production). They provide technical expertise in the use of database technology and are accountable for the overall performance of the enterprise’s database environment. Database Administrators work closely with business and system analysts and solution developers to define and resolve information flow and content issues—helping to transform business requirements into environment specific databases.
These professionals have a solid working knowledge of database administration methodologies and techniques, and a good understanding of logical and physical database design principles. They work well in a team environment and exhibit flexibility when addressing daily shifting work priorities.
Plans and organizes database activities regarding reliability, performance monitoring and tuning, security, backup and disaster recovery
Works with analysts to understand business needs.
Translates logical data models into physical database designs.
Develops physical databases.
Assists in the establishment of database system flows.
Develops and maintains enterprise data documentation and metadata models.
Develops and provides database requirements to system administrators.
Codes, edits, installs and verifies stored procedures and functions for accessing, maintaining, and populating databases.
Recommends and implements database solutions to support data integrity efforts.
Participates in projects that require testing and produces metrics and samples for further analysis.
Monitors utilization for capacity planning.
Troubleshoots and resolves application (ex., SQL) performance issues.
Monitors, analyzes database performance and calibrates DBMS parameters so that the database is tuned for optimal performance.
Monitors database replication performance.
Maintains development, production, and multiple testing environments
Performs upgrades of databases, adding new structures or elements.
Plans and manages the migration of databases.
Installs, configures and maintains the database management systems software.
Builds scripts automating the daily operations of database management.
Monitors transactions between application systems and the database for the purpose of identifying and improving inefficiencies.
Implements database backup and recovery procedures.
KNOWLEDGE, SKILLS AND ABILITIES:
Bachelor’s degree in programming/systems, computer science, information systems, or mathematics, specialized training, certification or equivalent work experience.
Has a broad level of understanding surrounding information systems and application and/or web standards.
Typically requires 3-5 years of database administration experience working with various database management systems (with Microsoft D365 as the prerequisite).
Experience in development of stored procedures and queries.
Technical expertise regarding data models, database design development and data mining.
Working knowledge of Microsoft data models, including Common Data Model and data handling in Dynamics 365.
Willingness and ability to travel domestically and internationally, as necessary.
Effective in written and verbal communication in English.
Preferred Skills, Knowledge and Experience:
Certified in MCSA: SQL Server.