The Sr. Database Engineer will provide technical expertise in the operation of Skechers IT infrastructure including supporting operational Relational and NoSQL databases, extracting, and loading data in disparate systems, configuring and tuning databases, communicating with clients, diagnosing and troubleshooting database and related issues. They will work closely with the Infrastructure, Systems, and Networking teams to deliver on key IT initiatives in a fast-paced environment. The Sr. Systems Engineer, Database is responsible for providing oversight, implementing appropriate access controls, and performing regular and effective audits of all technical users including operational support activities. The Sr. Systems Engineer, Database must possess in-depth technical aptitude in all areas of on-prem and cloud native databases, database design and administration. _ESSENTIAL JOB RESULTS-_ * * Participate in meetings and work groups to integrate activities, communicate issues, obtain approvals, resolve problems and maintain a level of knowledge pertaining to new developments, requirements, and policies. * Effectively consult and communicate with internal customers, vendors, and enterprise infrastructure teammates * Follow up with customers to identify areas of improvement * Provide technical support to research and ensure timely resolution of reported incidents * Respond to database service requests and contribute to plans and policies for the production management of critical, large, enterprise databases * Improve and automate regular processes, track issues, and document changes. * Write new stored procedures, functions, views, triggers, constraints. * Analyze access patterns and propose the best combination of indexes, constraints, foreign keys, and queries. * *_ADDITIONAL RESPONSIBILITIES_ * Other duties as assigned. *_SUPERVISORY RESPONSIBILITIES-_ * / /No *JOB REQUIREMENTS* * Expert in deploying On-prem databases to AWS Cloud infrastructure. * Expert in Disaster recovery, replication technologies, Informix upgrade * Microsoft SQL Server development and database administration experience including performance tuning, installation, upgrade, configuration in Windows environment * Review current database environments and make suggestions to improve database infrastructure * Perform health check monitoring and ensure timely resolution of all production issues. * Establish and maintain backup and disaster recovery policies and capacity planning. * Document and maintain technical specifications of company database systems, log support calls and related work with database vendors. * Excellent verbal and written analytical and communication skills with the ability to communicate technical material to a non-technical audience. * Must be able to work both independently and in a team environment * Must be a quick learner, self-motivated, proactive, and engaged. * Must be able to work on-calls during after-hours and weekends _EDUCATION AND EXPERIENCE_ * 5+ years of experience in Database Administration and Data warehousing. * Deep understanding of AWS Cloud components supporting systems, network, database infrastructure. * AWS database specialty and AWS Solution Architect Associate level course, a big plus. * Deep understanding of Cloud database technology such Amazon RDS * 5+ years of experience working on Linux, UNIX platforms * Experience with Linux shell scripting, Python scripting experience a plus * No SQL database knowledge on platforms such as MariaDB, CouchDB, IBM Cloudant * Experience administering enterprise databases such as Microsoft SQL Server, Informix. * Proven technical skills including infrastructure design * Ability to manage competing priorities in a complex environment * Self-starter with ability to work under minimal supervision. * Bachelor's degree or higher or equivalent years of experience To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The skills, abilities and physical demands described are representative of those duties that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities, who are otherwise qualified for the job position, to perform the essential functions. _PHYSICAL DEMANDS_ / /While performing the duties of this job, the employee is regularly required to stand; use hands to finger, handle, or feel, and talk or hear. The employee frequently is required to walk; sit, reach with hands and arms, and stoop, kneel. The employee is occasionally required to sit for long period of times. * * #LI-KG1
