SQL Database Administrator Sr * Review (Assessment) of tasks generated by the IT teams. * Support in installation´s applications with client’s suppliers * Monitoring of the Capacity and performance of the servers where the app bases are installed. * Analysis of the internal performance of the SQL engine and daily workload. * Sizing of space to be used by the SQL Engine according to the Project. * Management of Backup and Backup Policies.* Support to improve query performance, and the execution plans in customer developments. * Support for SQL Server in the Azure DevOps Implementations.* Design and implement Database Solutions working with the different developments teams.* Support to Install VMs with AO solution * Support for Installation, Migration, and Update of SQL Engines 2014, 2016, 2017, 2019 on Standalone / Cluster servers. * Support in Solutions that involves replication models of bases (Always On). * Support for the creation of Job Automated Maintenance Plans.
SQL Database Administrator Sr * Review (Assessment) of tickets generated by the customer. * Support in installation applications with client’s suppliers * Analysis of the internal performance of the SQL engine and daily workload. * Participation in the Weekly Infrastructure Committee with the client. * Attention of incidents Changes and Requirements of High Criticality.* Support for Installation, Migration and Update of SQL Engines 2008,2008R2,2012,2014,2016,2017 on Standalone / Cluster servers. * Support in Solutions that involves replication models of bases (Log shipping, Mirror, Always On). * Support for the creation of Job Automated Maintenance Plans. * Daily management of tools under the Scrum Agile and ITIL methodology. * Support for the management of historical data in productive bases (partition or compression). * Integrated Security Management in SQL engines with Active Directory. * Support to improve query performance, and the execution plans in customer developments.
Database Administrator. (SQL SERVER, SYBASE, ORACLE) • Report Management RCA (Root Cause analysis). • Services Management 7x24. • Manage tools for change control, Incidents y requirements under procedures of Change Management in ITIL methodology • Environments Preparation, Database Snapshot Configuration, previous and post checks ok Failover, Switchover in SO Unix y Windows. • Backup y Restore of DB from disk to a device, check the Backup RMAN execution, verification of Oracle export, and crontab as well. • Execution of Scripts, WorkAround, Querys, in different environments Development, Production, Audit. • Manage BCP to make a Bulk copy in SO Unix y Windows. A reboot of kernel. • Manage job scheduler, historical job, execution step by step, and verification of the Schedule, etc. • Database Implementation or running Rebuild index and tunning databases. • Users Administration, check and assign user roles in table, views, refresh the alias in the DB, in table Space.