Major technology company requests:
sql dba
requirements:
* degree in it / computer science / related discipline
* advanced english
experience:
min 5+ years of experience overall;
objetivo:
* supports the day to day availability and performance of s sqlserver operational support systems including the ability to troubleshoot and isolate moderate to complex system/application issues for sqlserver based operating systems and hardware.
proposes and implements complex system enhancements (software and hardware updates) that will improve the performance and reliability of the system. Manages the configuration of the sqlserver .
supports the rollout of complex projects that impact sqlserver operational support systems. Installing, configuring, and testing different produce sets on sqlserver 2008r2,2012 ,2014,2016,2017 and 2019
provides 24x7 support on a rotating basis is required and responsible for performing the job in accordance client vision and values
funciones del puesto:
* roles & responsibilities:
* responsible to support 1000+ sql db servers(2000 to 2019) and provide oncal support.
* responsible for all operational aspects of sql server database systems including performance, integrity and security.
* plan and execute database migration from microsoft sql server to postgre
* respond to incidents, troubleshoot issues and provide advice on improving database performance.
* monitor performance of the database and the database servers; determine optimal performance parameters for the database server, operating system etc. and tune as needed.
* carry out periodic maintenance of the database including table extents, indexes etc.
* carry out periodic maintenance of the database platform in terms of software updates, security updates and service packs.
* plan, test and execute a data migration from a microsoft sql server dbms to postgre db
* ensure that redundant database systems are properly maintained, and that they are available for activation as and when required.
* carry out database design tasks in conjunction with the software development team and implement enhancements and modifications to the database.
* monitor database logs and take corrective action on issues if required.
* participate 24x7 on call support on a weekly rotating schedule, including weekends
* develop and maintain standard operating procedures/documentation
* experience in legacy db versions (sqlserver 200,2005,2008 ) as he will be part of migrations to postgre and upgrade to sql server 2019
* provide escalation support for database related issues required industry experience:
5 to 7 years' experience in sqlserver and knowledge on other rdbms db's
we offer:
* competitive salary: 100% payroll.
* vacation bonus: 25% of daily salary.
* christmas bonus: 15 days of base salary.
* profit sharing.
* savings fund: 4% of monthly salary subject to the legal limit (payable every 6 months).
* food stamps: 4% of monthly salary subject to the upper limit set by mexican law.
* major medical insurance for the employee and their eligible dependents (spouse, children).
* life insurance
* employee professional development through training
interested applicants should send their cv in english to or to whatsapp at /
tipo de puesto: tiempo completo
sueldo: $69, $70,000.00 al mes
experiencia:
* gestiona la configuración de sql server.: 5 años (obligatorio)
* sql server 2008 r2, 2012, 2014, 2016, 2017 y 2019.: 5 años (obligatorio)
* sql server: 5 años (obligatorio)
* scripting de shell y automatización: 5 años (obligatorio)
* sistemas operativos y hardware basados en sql server.: 5 años (obligatorio)
idioma:
* ingles (obligatorio)
lugar de trabajo: empleo presencial