.we are going to build a 24x7 dba service line within our managed services team, with *experience in management (service now or similar) and ticket systems*.proposed shift hours in eastern usa times (will have to adjust for daylight savings time):- 9am - 6pm- 5pm - 1am- 1am - 10am*general day to day responsibilities*:- extremely strong written & spoken english (there will be client interaction on a daily basis which will require very strong english skills)- ability to work independently- provision, install, upgrade, and manage databases across various environments, including on-premises and cloud (azure) solutions, ensuring optimal performance and reliability.- collaborate in documenting, updating, and communicating key processes and documentation within the database environment.- troubleshoot and resolve performance issues, integration challenges, and other database-related concerns promptly and effectively.- determine the best placement of databases in on-premises or cloud solutions based on performance, security, and scalability requirements.- implement and maintain best practices for database administration, including backups, security measures, and disaster recovery strategies.- collaborate with cross-functional teams to implement new processes, change management, and problem management strategies related to the database ecosystem.- database administration proficiency with at least following rdbms platforms: ms sql server*experience with*:- database administration tools used for data management and design (such as sql developer, etc.
)- support and troubleshooting of microsoft sql server- integration of bi (powerbi, ssis), reporting (ssrs), and analytic tools with dbms platforms- supporting large data warehouses- sql clustering troubleshooting- data transformation and integration- azure database technologies- leverage logic monitor for monitoring and alerting- service now fundamental*ability to*:- plan and install database software and database systems- develop tools, utilities, and procedures to automate maintenance functions- develop database stored procedures and triggers- define and develop tests for verification and validation of database solutions and installations*knowledge of*:- database performance tuning techniques and tools, with ability to debug and tune sql including t-sql queries.- database backup and recovery techniques and tools, ha/replication and disaster recovery- hardware and operating systems (linux and windows) including scripting, file management, and server security- database modeling including both logical and physical design and referential integrity concepts- software development methodologies, tools, and processes- database security principles, implementation, and management- successful teaming and communication skills including documentation abilities- itil it service management framework- automation and scripting in languages such as powershell, perl, or python