Database Administration Job Title: Database Administrator Location: Bogotá, Colombia (100% remote) Duration: 12 months Primary duties and responsibilities: - Sr. Database Administrator II includes project and support development, backup/recovery, new SQL Server builds, database migrations, and disaster recovery. The database team ensures Client databases are backed up, recoverable, stable, and secure. Strategic Objectives Demonstrate a high degree of proficiency in project management techniques including time estimates, resource allocation, project status updates, and managing critical path and milestone deadlines. Knowledgeable of current IT industry trends and potential impact to database systems. Possess cross-functional understanding of the company's business environment and support overall IT management team to drive departmental objectives. Performance and query tuning, storage architecture, and best practices for SQL Server on virtualized hardware and in cloud environments. Capacity planning & forecasting of available host resources and allocation based on project/support requirements. Tactical Responsibilities Provide ongoing daily support of mission-critical DB2 and SQL Server database systems including 24x7 on-call rotation. Support and implement tools and processes to monitor the systems extensively. Configure, modify, deployment of virtual DB2 and SQL Servers. Administration, configuration, security access, backup, restore, patching, and implementation of SSAS/SSRS. Required Experience & Technical Skills 5-7 years of direct enterprise IT experience with a strong understanding of relational and warehouse database structures, database and development theory, datacenter infrastructure, SAN methodologies and topology, and virtualization topology. 5-7 years of Microsoft SQL Server 2016 (and above) experience. 3-5 years of Microsoft Windows Server 2016 (and above) experience. 1-2 years of Microsoft SQL Server Analysis Services & Reporting Services experience. Familiarity or willingness to learn to implement and support DB2 LUW. Experience with SSRS report tuning, development, and deployment. Experience with SSAS cube deployment. Experience with database migrations to new SQL Server accounting for all objects associated with the database. Logins, jobs, SSIS packages, linked servers, credentials, proxies, etc. Experience with administration, design, and implementation of Windows high availability clustering in relation to SQL Server 2016, SQL Server 2019 or above. Extensive experience working with Performance counters to interpret the health of a server. Understanding of server-network and server-SAN interfaces. Expertise with Windows PowerShell scripting to automate administrative functions. Administration, patching, and install of SQL Server based on design requirements. Expertise in configuration, modification, and security access topology for SQL Server. Implementation experience with upgrading between SQL Server 2016 - SQL Server 2022. Expertise and direct implementation experience in backup and restore methodologies and recoverability. Expertise and direct implementation experience in disaster recovery methodologies (mirroring, log-shipping, replication, multi-site high availability groups). Experience in architecture and design of SQL Server physical and virtual environments based on service level requirements. Expertise and direct implementation experience in file group design, table partitioning, table and index compression, and determining data distribution cardinality. Expertise and direct implementation experience in database tuning, monitoring, tracing, and maintenance of relational databases, warehouse databases, and VLDB environments. Expert understanding of deadlock analysis, wait-type analysis, and blocking transactions. Expert understanding of SQL development methodologies (stored procedures, triggers, UDTs, scalar and table value UDFs, views, cross-database query, linked-server, and sequences). Strong understanding of relational OLTP database modeling. Experience with OLAP database modeling (fact/dimension models, slowly-changing dimensions). Expert understanding of capabilities and limitations of SQL Server/SSAS/SSRS features across SQL Server versions and editions.