**Responsibilities**:
- Install and configure new Microsoft SQL Server instances, including AlwaysOn availability groups and failover clustering.
- Review, analyze, and evaluate business systems and user needs by facilitating brainstorming sessions with stakeholders.
- Highly skilled at database design, installations, conversions
- Responsible for database backup and recovery procedures, access security and database integrity, physical data storage design and data storage management
- Participates in Database Management System selection and maintains database performance.
- Engage in ongoing process improvement.
- Experienced in Database Performance, Maintenance and Development to perform the following:
- Database management including backups, recovery, and maintenance.
- Database management for export, import and mass data loads
- Analyzes and generation of all tables and index statistics
- Monitoring and resolving data lock issues
- Check all statistics related to memory, locks, I/O, database response time, wait events, top sessions, and background processes
- On-Line Transaction Processing (OLTP) to capture, validate and store large amounts of transactions
- Create indexes to achieve critical dataset response time for time sensitive reports.
- Install SQL Server service packs and updates.
- Configure and manage SQL Security settings.
- Make system design recommendations according to Microsoft SQL Server best practices.
- Manage database backup & recovery & DR planning in collaboration with IT manager and
System Engineer.
- Create, modify, and optimize SQL Server Agent jobs and maintenance plans.
- Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs and resolve issues in
a timely manner.
- Responsible for T-SQL query tuning
- Responsible for database migrations and server upgrades.
- Develop documentation and training of routine database administration tasks and train server
operations staff on these tasks.
- Responsible for ETL of large data into SQL Server Author and modify SQL Server Reporting
- T-SQL Programming Perform additional tasks as assigned
- Should have thorough knowledge of Azure databases including (IaaS, PaaS and DbaaS)
- Having knowledge of PostgreSQL, MySQL, MongoDB would be value add
**Education and Experience Requirements**:
- Bachelor's Degree in Computer Science, Computer Engineering, Technology or equivalent
- MCSE/MCSA certifications preferred
- Experience with Linux and Windows Server environments
- Good to have experience with database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB)
- Experience with cloud services (AWS, Microsoft Azure) a plus
- Experience in Logical and Physical Database modelling
- Must have working experience in a clustered Windows environment.
- Must have configuration and troubleshooting of SQL Server Integration Services (SSIS)
- Must have configuration and troubleshooting of SQL Server Reporting Services (SSRS)
Pay: $3,000.00 - $3,200.00 per month
Ability to commute/relocate:
- México Libre, Tamps.
: Reliably commute or planning to relocate before starting work (required)