Position Title: Senior Engineer, Cloud Database (P4)
Company Summary:
Crown Castle is the nation’s largest provider of shared communications infrastructure: towers, small cells and fiber. It all works together to meet unprecedented demand-connecting people and communities and transforming the way we do business. Whenever you make a call, track a workout or stream music and videos, we’re the ones providing the communications infrastructure that makes it all possible. From 5G and the internet of things to drones, autonomous vehicles and AR/VR, we enable the technologies that help people stay safe, connected and ready for the future. Crown Castle is a Fortune 500 company, publicly traded on the S&P 500, and one of the largest Real Estate Investment Trusts in the US, with an enterprise value of ~$70B.
We offer a total benefits package and professional growth development for teammates in any stage of their career. Along with caring for our teammates, we’re an active member in the communities where we live, work and do business. We have a responsibility to give back, which we do through our Connected by Good program. Giving back allows us to improve public spaces where people connect, promote public safety and advance access to education and technology.
Role:
As a Sr Cloud Database Engineer, you will be responsible for migrating existing databases to AWS. You will design, automate, and manage databases as a service leveraging deep experience in Open-Source database technologies like MySQL, Aurora, PostgreSQL, CloudSQL and other Cloud Native database technologies.
Responsibilities:
- Design and implement highly available, scalable, and secure database solutions in AWS
- Deploy, configure, tune, monitor, and maintain cloud databases in the production, development, and quality assurance environments
- Optimize and tune Redshift cluster and queries to support multiple Analytics and Visualization platforms • Implement Redshift Workload Management (WML) to prioritize workloads and manage concurrency issues
- Design and Implement Monitoring and Alerting system for AWS Redshift cluster performance and uptime
- Design and implement Redshift Disaster Recovery Plan
- Partner with developers and other stakeholders to optimize database performance and ensure data integrity
- Stay up to date with the latest cloud and database technologies and provide recommendations for improving our infrastructure
- Leverage AWS-based architecture and partner with DevSecOps to develop scripts to support continuous deployment process and maintain the environment via TFS/Terraform/Liquibase
- Design server/server-less resource requirements for specific applications and performance metrics
- Partner with cloud & data architects on database design patterns/models
- Partner with application teams on their cloud adoption and application modernization journey
Expectations
- Self-motivated individual who can handle ambiguous/undefined problems and think abstractly to deliver results
- Demonstrate a strong sense of ownership, urgency, and drive as well as the ability to work well with diverse teams.
- Effectively articulate technical challenges and solutions to business users and other technical teams
- Develop compelling insights and logical arguments to persuade others
- Demonstrate curiosity and flexibility to diverse styles and perspectives that could drive business outcomes
- Mentor team members and conduct periodic learning sessions
Education/Certifications:
- Bachelor’s degree in Computer Science, Engineering, Information Science, Math or related discipline
- AWS cloud certifications (Cloud Practitioner and/or Cloud Database)
Experience/Minimum Requirements:
- 8+ years of experience in managing and automating mission critical production workloads on MySQL, PostgreSQL, CloudSQL. Aurora and other Cloud native databases in a large, complex environment
- 3+ years of experience designing and managing cloud database technologies such as Amazon RDS, Oracle Cloud, Snowflake, and MongoDB
- Experience with Data Warehouse technologies such as AWS Redshift, Snowflake, Azure Data Warehouse, etc
- Expertise in database administration for large Data warehouse/datamart implementations including configuration, implementation, data modeling, maintenance, redundancy/HA/DR, security, troubleshooting/performance tuning, upgrades, database, data and server migrations, SQL
- Cloud migration experience
- Infrastructure as code (IaC) principles and experience with tools such as Terraform, CloudFormation, Liquibase, Flyway or Ansible. Thorough understanding of Software Development Life Cycle (SDLC) best practices.
- Comfort and experience working in an Agile environment
Working Conditions: This is a remote role with the expectation of on-site/in-person collaboration with teammates and stakeholders for moments that matter and may require up to 15-20% travel.
For New York City, Colorado, California, and Washington residents – The hiring range offered for this position is $148,000 – $170,000 annually. In addition to salary, employees are eligible for an annual bonus of up to 20% of annual salary and restricted stock. Employees (and their families) are eligible for medical, dental, vision, and basic life insurance. Employees are able to enroll in our company’s 401k plan. Employees will also receive 18 days of paid time off each year and 12 paid holidays throughout the calendar year.
#LI-CM1
#LI-Remote
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)