Database Administration - Database Administration Database Administration #25-358885 Share on Job Description Job Title: Database Administrator Location: Bogotá Colombia (100% remote) Duration: 12 Months Primary duties and responsibilities: - Sr. Database Administrator II include but are not limited to project and support development, backup / recovery, new SQL Server builds, database migrations and disaster recovery. The database team works together ensuring Client GETS database platforms consisting of 98% SQL Server and 2% DB2 LUW (850+ databases) are backed up, recoverable, stable and secure. Strategic: - 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: - 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. #J-18808-Ljbffr