Senior Database Administrator

Description

Company Overview

Lean Tech is a pioneering force in providing impactful technological solutions, dedicated to excellence and innovation. Our mission is centered around transforming industries with cutting-edge technology, fostering an environment that thrives on creativity and collaboration. Known for delivering unparalleled quality and efficiency, Lean Tech excels in facilitating enhanced process management and streamlining operations for our diverse clientele. We hold a leadership position
within the tech industry, backed by a robust global presence and strategic locations.

Position Overview

In this senior role at Lean Tech, you will be the cornerstone of our SQL Server environment hosted in AWS, ensuring its performance, reliability, and security. You will execute this by owning database management processes and approvals, optimizing database performance, and collaborating closely with developers to design efficient schemas and optimize SQL execution. This role requires significant interaction with multidisciplinary teams in an agile environment, where your expertise will drive strategic and tactical database projects. You will adhere to compliance frameworks with an emphasis on SOC2, and regularly update documentation using tools like Confluence and Word. Embrace the challenge of maintaining high standards in database security, maintenance, redundancy, and disaster recovery while staying abreast of technological advancements. Your work
will have a direct impact on enhancing our cloud-based SaaS services, ensuring business operations run seamlessly worldwide.

Key Responsibilities

• Lead the maintenance and optimization of AWS-hosted SQL Server databases to ensure peak performance and reliability.
• Collaborate with developers using agile methodologies to design efficient database schemas and enforce best practices for SQL code.
• Perform advanced SQL Server performance tuning, query optimization, and indexing strategies to improve database efficiency.
• Manage comprehensive database backup, restore, and disaster recovery plans, ensuring business continuity.
• Implement and maintain strong database security controls, including access management, encryption, and compliance with SOC2 frameworks.
• Regularly update and patch SQL Server environments with the latest security updates and AWS optimizations.
• Plan and execute database capacity planning and scalability initiatives to support future growth.
• Set up and utilize automation tools to effectively monitor database health, performance metrics, and alerting systems.
• Maintain accurate database documentation using tools like Confluence and Word, ensuring all records are up-to-date.
• Actively participate in cross-functional projects, providing database expertise and solutions to enhance overall project outcomes.

Required Skills & Experience

• Minimum of 5 years of experience as a SQL Server Database
• Administrator/Engineer, preferably in a cloud-based SaaS environment.
• Advanced proficiency in SQL Server, with a focus on performance tuning, query optimization, and indexing strategies.
• Extensive experience in AWS-hosted SQL Server environments, particularly with EC2-based deployments.
• Strong expertise in T-SQL, including stored procedures, triggers, and database migrations.
• Advanced level in database security, including access controls, encryption, and SOC2 compliance frameworks.
• Hands-on experience with managing database backups, restores, and developing disaster recovery plans.
• Proficient in collaborating with developers for database design and optimizing SQL execution.
• Familiarity with automation tools for database maintenance and monitoring.
• Excellent troubleshooting and problem-solving skills.
• Effective communication skills to convey complex database concepts to developers and stakeholders.
• Experience with Confluence and Word for documentation purposes.
• Knowledge of agile methodologies for collaboration with developers.

Nice to Have Skills

• Familiarity with analytics platforms like Snowflake and Power BI for enhanced
  data analysis capabilities.
• Knowledge of advanced AWS services beyond EC2, such as RDS or Lambda, for diversified cloud solutions.
• Certification in AWS Certified Solutions Architect or Database Specialty to validate cloud expertise.
• Strong understanding of DevOps practices to align with agile methodologies effectively.
• Proficiency in alternative automation tools not previously mentioned for innovative database management solutions.

Soft Skills

• Effective Communication: Clearly articulate complex database concepts to developers and stakeholders, ensuring smooth collaboration and understanding at all levels.
• Leadership: Demonstrate leadership capabilities by managing database related processes and approvals, and guiding teams through technical challenges with confidence.
• Problem Solving: Employ strong troubleshooting skills to swiftly identify and resolve database performance issues, minimizing downtime and enhancing system efficiency.
• Collaborative Teamwork: Work closely within agile methodologies, partnering with developers to optimize database designs and processes, ensuring alignment with project goals.
• Attention to Detail: Maintain meticulous documentation using preferred tools such as Confluence and Word, ensuring all database processes are thoroughly recorded and easy to follow.

Why You Will Love Working with Us

• Join a powerful tech workforce and help us change the world through technology
• Professional development opportunities with international customers
• Collaborative work environment
• Career path and mentorship programs that will lead to new levels.

Join Lean Tech and contribute to shaping the data landscape within a dynamic and growing organization. Your skills will be honed, and your contributions will play a vital role in our continued success. Lean Tech is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.