Overview
join our team as a sql server dba! are you a skilled sql server database administrator looking for an exciting new opportunity? We are seeking a talented professional to join our team and ensure the high availability and performance of our sql server databases.
responsibilities
* administer, maintain, and optimize sql server databases.
* monitor and troubleshoot database performance issues.
* provide technical support and guidance on sql server best practices.
* coordinate security updates and patches with the eo team as part of general sql server maintenance.
* manage disk space for databases, logs, and backups; optimize index fragmentation; monitor sql server performance.
* ha/dr tasks: monitor always on availability groups and failover cluster instances; check replication status and perform regular failover testing; ensure backups are tested and restorable.
* ssrs maintenance: manage permissions and security, handle data source connections and report layout changes, and develop new reports.
* ssas tasks: monitor jobs related to refreshing cubes; manage ssas role-based access; troubleshoot data refresh failures.
* security: manage server and database permissions, service accounts, and credentials.
qualifications
* sql-related responsibilities: maintain sql agent jobs, manage ssis, monitor execution performance, retain and clean up job history, and document job dependencies and execution order.
* 5 years of experience supporting relational databases as a dba, with multiple distributed rdbmss or a focus in oracle and related tools; oracle dba (oca/ocp) certificate will have added advantage.
* experience optimizing large databases for enterprise use; prior exposure to 24x7 database environments is desirable; bs or equivalent desired.
* provide development and/or production support, create database structures and objects, modify schema for enhancements or performance, and develop documentation and plans; perform backup and recovery planning and storage management; create database-related scripts and programs.
detailed description and job requirements
provide development and/or production support. This includes creating primary database storage structures, designing and creating primary objects, modifying database structure as necessary for enhancements or performance, creating documentation, designing interfaces, database objects, and creating plans. Monitor and optimize performance of the database, plan for backup and recovery of the database, and allocate system storage and plan future storage needs. Create database-related scripts and programs to support development and production environments. Research, evaluate, design, test, recommend, and plan implementation of new or improved rdbms, etl and database tools. Job duties are varied and complex utilizing independent judgment. May have project lead role. 5 years of experience supporting relational databases as a dba, with multiple distributed relational dbsms or a focus in oracle and related tools. Exposure and practice at using the dbms to optimize performance of large databases for enterprise use is preferred. Experience with an organization with a key 24 x 7 reliance on its database is desirable. Bs or equivalent desired.
affirmative action / eeo
oracle is an affirmative action-equal employment opportunity employer. all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability, protected veterans status, age, or any other characteristic protected by law.
job: information technology
location: mx-mx,mexico-guadalajara/zapopan
job type: regular employee hire
organization: oracle
#j-18808-ljbffr