Responsibilities:
· Implement the future data architecture in Pandologic, providing 24/7 real-time and near real-time scalable and resilient data store for our growing stack of products and microservices
· Administrate, provision and monitor dozens of database instances
· Develop strategic solutions to recurring problems
· Guide development teams and mentor other team members
· Use your creativity to resolve complex and high scale data related issues
Requirements:
· 5+ yrs. of experience as a SQL Server 2012 and above DBA (preferred in hyper-growth startups)
· 3+ yrs. of experience designing, implementing, monitoring, and troubleshooting databases
· 3+ yrs. Experience in developing and maintaining Stored Procedures, Functions, Views, Triggers and relevant database objects
· Experience with additional Relational databases, such as MySQL – Advantage
· Experience with NoSQL databases such as MongoDB and Elastic Search – Advantage
· Experience with problem analysis and tuning on multiple database technologies
· Design, Analyze, Manage and Create relational Database
· Experiece with DB troubleshooting and performance optimization
· Knowledge with SSIS, SSRS, SSAS, ETL’s and BI approach
· Windows and power shell scripting skills
· Windows Server and OS fundamentals