Please note this is Hybrid role with 3 days onsite at our Houston office.
- Deep experience in SQL Database Development, TSQL, Stored Procedures, OLTP, and working with large data sets.
- Improve database reliability and performance from within the DevOps team while partnering with Engineering to ensure quality and stability with new releases.
- Proficiency in working with Azure DevOps and Azure Services, such as, Azure SQL Database, Azure Data factory, Cosmos DB and Blob Storage.
- Experience in Data Modeling and Schema Design skills, including Normalization and De-Normalization.
- Work with peer DevOps Engineers to roll out changes to our production environment and help mitigate database-related production incidents.
- Provide database expertise to Engineering teams (through reviews of database migrations, queries, and performance optimizations)
- Plan for and extrapolate data growth and manage the capacity database infrastructure.
- Support and debug production database issues across services and environments
- Azure Cloud experience, ADF, Azure Synapse, and Data Lakes are preferred skills.
Requirements
- Strong experience in writing high performing complex queries Azure SQL.
- T-SQL Performance Troubleshooting and Tuning
- SQL API and Stored Procs for Azure Cosmos DB.
- Azure Search, Azure Table Storage, Azure Blob Storage
- Experience in working with Redis
- Familiarity with C# scripts, Java Scripts & KQL
- Azure DevOps CICD pipelines for SQL Projects
This job description provides many examples of the types of responsibilities required but is in not intended to be a comprehensive list. The incumbent will complete other job responsibilities as needed which are not specifically described in this document.
P97's employees are recognized as a thought leader by peers, customers, and others in the industry with a respected reputation both internally and externally. If you want to be the newest member of a vibrant group of technology leaders in an innovative and entrepreneurial environment, then apply online today to start building solutions that customers will love to use and join a company that truly rewards your hard work and values your talented contributions. For a complete list of our open positions, please visit our website at www.P97.com and career center at http://p97.com/careers/ .
P97 rewards your hard work with a competitive compensation plan, comprehensive benefits plan, stock options, 401k with a match, PTO package, and amazing opportunities for career growth and personal development.
P97 is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to sex, race, color, religion, national origin, age, marital status, political affiliation, sexual orientation, gender identity, genetic information, disability, or protected veteran status. We are committed to providing a workplace free of any discrimination or harassment.
No calls or agencies please.