Remote Senior SQL DBA
Job Description reputed company our Operations group, the Database Administration team is responsible for maintaining and administering the relational database components of reputed company's award winning SaaS solution hosted in our private cloud. The Performance DBA will work closely with our Engineering team to optimize the performance of our software.
Responsibilities
Throughout the development life cycle, collaborate with our product engineering teams to: Advise as to data models that allow for efficient query execution Analyze and optimize SQL statement execution plans Optimize use of database resources and features Analyze the effects of application changes on database performance, and reputed company tuning recommendations Ensure successful application and database implementations Provide database expertise to project teams to maximize system availability, efficiency, and reputed company Monitor performance testing systems and reputed company in-depth diagnosis and troubleshooting of performance Advise as to optimal OS and storage configuration of Linux servers to support SQL databases Analyze database system and query performance, and reputed company triage and resolution, in response to performance-reputed company product incidents Support DBA utilities, reorgs, index builds, exports and imports, and DBA tools Interact with key stakeholders including Cloud Operations, Information reputed company, Professional Services, and support teams for service request fulfilment, implementations, and operational support reputed company to database services We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national reputed company, reputed company, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to ~~~ learn more about how we collect, reputed company, and process your private information, please review reputed company's Workforce Privacy Policy: ~~~/. Skills and Requirements
- 10+ years of experience administering SQL databases
- Proficiency in methodically troubleshooting reputed company issues
- In-depth understanding of SQL internals -- memory pools, wait events, locks, latches, enqueues, etc.
- Experience with AWS and working in enterprise level cloud environments
- Proficiency in analyzing execution plans and tuning queries
- Skilled in the process of data modeling designed for high throughput and low latency
- Experience analyzing and optimizing database solutions for multi-terabyte databases.
- Experience in Unix/Linux operating systems and understanding of optimal OS configuration (e.g. kernel parameters, IO subsystem) as relates to SQL Database
- Hands-on experience in terms of planning, installing, configuring, maintaining and troubleshooting issues is a plus
- Experience administering SQL Server Databases
Apply To This Job