The Database Administrator II (DBA II) will be responsible for the management and maintenance of databases that store critical data for business systems and analytics. This role is essential in ensuring that databases are optimized for performance, availability, and security. The DBA II will work closely with Data Engineers, Developers, and System Administrators to set up backup and recovery procedures, monitor database performance, and implement necessary security measures to protect sensitive data. Additionally, the DBA II will assist in the design and implementation of data models and schemas that support the efficient storage and retrieval of data for analysis. In terms of database management and maintenance, the DBA II will manage and maintain all databases, ensuring high availability and reliability. Regular database backups and recovery procedures will be performed, alongside monitoring database performance and tuning for optimization and efficiency. The DBA II will also participate in the design, development, and maintenance of scalable and efficient data pipelines and databases, collaborating with stakeholders to understand data requirements and translating them into technical specifications and data models. The role also involves developing and implementing Extract, Transform, Load (ETL) processes to acquire, clean, and transform data from various sources into usable formats, ensuring data integrity, consistency, and quality throughout the ETL processes. The DBA II will participate in the design, build, and maintenance of data warehouses and data lakes to support reporting, analytics, and business intelligence initiatives, implementing data partitioning, indexing, and optimization strategies to improve query performance and efficiency. Furthermore, the DBA II will adhere to and enforce data governance policies, standards, and regulations, implementing data security measures, including access controls, encryption, and data masking techniques. The DBA II will also optimize data processes and infrastructure to improve performance, scalability, and reliability, conducting performance tuning, query optimization, and indexing to enhance data retrieval and processing speed. The role requires collaboration with cross-functional teams, business analysts, and IT systems analysts to understand their business requirements and provide data and custom application solutions. Communication of technical concepts and solutions effectively to both technical and non-technical stakeholders is crucial, as is staying updated with the latest industry trends, technologies, and best practices related to database administration.