Principal Database Administrator, CloudCheckr - Remote
Spot is a fast-paced startup that operates within NetApp and enjoys all perks & benefits of a large-scale organization while maintaining the startup culture, mentality, and pace. By continuously optimizing cloud infrastructure to always be highly available and for the lowest possible cost, we revolutionize the way businesses manage their cloud. With the recent acquisition of CloudCheckr, Spot by Netapp's footprint now extends into pure-play cloud management by adding cloud billing analytics and cost management capability. This is an incredible chance to get in on the ground floor of an exciting high growth business unit, which combines the best of a startup environment with the resources of a public company.We are looking for a seasoned Principal DBA / Database Engineer to oversee all aspects of Database lifecycle management.Job Summary:The Principal DBA or Principal Database Engineer will oversee the management Databases used in CloudCheckr. This role will report directly to the Vice President of Operations on the organization's Operations team composed of DevOps, SecOps, and IT.Technical Requirements Experience with AWS RDS, complex Microsoft SQL Server administration and management is required. An advanced level of understanding of SQL Server implementations, maintenance, performance tuning, and optimization. Experience with RedShift is a plus. Expert understanding of the Stored Procedures, T-SQL language, SQL Server backup/restore concepts and its implementations, performance tuning and optimization, index design, and management, SQL Server security concepts and implementations, filegroups and data file layouts, concurrency, locking concepts, SQL Server installations and configurations, Windows/SQL clustering and Availability Groups, high availability, disaster recovery, transactional replication concepts and implementations (clustering, mirroring, replication, log shipping, availability groups). Expert with SQL Server tools, including SSMS, Profiler, Tuning advisor, Query Store, Configuration Manager, Execution Plans, Expert skills in using tools, system tables, stored procedures, and dynamic management views. Expert in troubleshooting Windows clustering as well as transactional replication, mirroring, replication, log shipping, availability groups. The ability to use the SQL command line and DAC. Working knowledge of Git and Bitbucket. Use of built-in and 3rd party monitoring tools (New Relic, SolarWinds Database Performance Analyzer). We use New Relic. Advanced understanding of wait statistics, execution plans and performance tuning concepts, table partitioning, Windows system administration.Functional Requirements Excellent interpersonal, written, and verbal communication skills. Ability to effectively facilitate communications and collaborate with all staff levels, as well as work independently on complex projects and tasks. Strong customer service and interpersonal skills. Strong organizational skills. Ability to prioritize workload independently. Motivated to learn and apply new concepts quickly. Stay informed of the latest database and related technologies and provide feedback and recommendations to peers and management. Effectively communicate with multiple levels of the technical, business, and management community regarding service, process, and technical issues. Advanced knowledge of service levels and business impacts of system unavailability. Develop and maintain standards for implementation, maintenance, and optimization. Review performance and capacity planning reports and make recommendations to management. Implement approved recommendations. Recognize patterns of problems, issues, or opportunities and resolve them on a scale larger than incident, eg, problem management. Create, communicate, and implement solutions to address integration, technical, service, or process issues across multiple environments. Provide significant influence in designing processes and procedures. Remain informed of technology and process enhancements within the industry and proactively shares with peers. Demonstrate advanced ability to successfully develop, plan, implement and test systems. Accurately logs and tracks all problems or work utilizing existing problem management or project management tools. Propose solutions using data analysis for increased effectiveness/efficiency. Solutions are expected to be actionable. Demonstrate strong project management and influence skills.About the Role: Act as the lead on mid to large size projects that involve primarily DataBases and potentially Data Warehouses or Data Lakes. Directly interact with the technical architects and drive database infrastructure solutions. Long-term planning for scalability of the database infrastructure. Be responsible for analyzing business requirements; determining appropriate technical approaches and developing specifications for implementation. Design, develop, and perform complex software installations and configuration changes for primarily DataBases and potentially Data Warehouses or Data Lakes. Establish and enforce all database standards. Analyze all informational requirements of new or production systems and develop database specifications. Establish and enforce controls to ensure database integrity. Expected to lead technical design activities, produce sizing estimates, consult on testing plans, and participate in all related software build and deployment activities. Assist peers and other database administrators with complex operational maintenance activities. Work closely with the Operations staff to diagnose and resolve escalated technical issues with production systems. Define strategies for backups, migration of database changes, and longer-term system growth. Lead performance analysis and tuning of the databases and applications. Develop health checks/monitors for monitoring systems. Maintain and improve the build, management, and deployment framework and participate in the design and documentation of this environment. Interface with application owners and developers to resolve advanced technical issues. Participates in the incident and event escalation process, including problem management. Participate in root cause analysis by gathering and reviewing pertinent logs and collaborating with peers and management. Utilizes monitoring and troubleshooting tools to restore service. Additional duties as assigned.Qualification Bachelor's Degree in Information Technology or Computer Science from an accredited college or university, or equivalent work experience. Minimum of ten (10) years related experience to include in-depth experience in Database Administration and/or Database Engineering. AWS RDS and Microsoft SQL Server experience is required. Proven track record of building and leading successful Database team.EEO/AA Employer/Vet/DisabledDid you know Statistics show women apply to jobs only when they're 100% qualified. But no one is 100% qualified. We encourage you to shift the trend and apply anyway! We look forward to hearing from you.Why NetApp?In a world full of generalists, NetApp is a specialist. No one knows how to elevate the world's biggest clouds like NetApp. We are data-driven and empowered to innovate. Trust, integrity, and teamwork all combine to make a difference for our customers, partners, and communities.We expect a healthy work-life balance. Our volunteer time off program is best in class, offering employees 40 hours of paid time off per year to volunteer with their favorite organizations. We provide comprehensive medical, dental, wellness, and vision plans for you and your family. We offer educational assistance, legal services, and access to discounts. We also offer financial savings programs to help you plan for your future.If you run toward knowledge and problem-solving, join us.Colorado Residents Only: If the Company determines this role will be performed in Colorado, the starting salary for this position is (.9 compa ). This role could be eligible for comprehensive benefits including: Medical, Dental, Vision, Life, 401(K), Paid Time off (PTO), Company bonus, Employee stock purchase plan, and restricted stocks (RSU's) . Final compensation will be dependent on various factors such as location, qualifications, certifications, relevant work experience and other factors, consistent with applicable law.As a US federal contractor, in accordance with President Biden's recent Executive Order for US federal contractors, all US employees of NetApp must be fully vaccinated against COVID-19 if they work at a Company location or remotely. If there is a medical or religious reason preventing you from receiving the COVID-19 vaccination, you must request and be approved for one of the legally acceptable exemptions.