Senior Database Administrator

Introduction:

Our goal at Pivotree is to help accelerate the future of frictionless commerce. We will help lead this change over the next decade because we believe a future where technology is embedded intimately into all aspects of our everyday lives can benefit everyone and will shape the interactions with the brands we love. We will help shape the future of frictionless commerce by working together with some of the best brands in the world and some of the best people in the industry to leverage converging technologies that will make it possible to accelerate frictionless commerce faster than ever.

Pivotree provides services focused on the design, implementation, management, and maintenance of complex ecommerce solutions for large enterprises. We provide the technical skills necessary to enable the effective use of technologies combined with the business context to leverage a solution to solve our clients' business challenges. We strive to fill the gaps in available technology with our own IP to reduce the barriers to adoption.We enable inclusive, immersive and highly personalized experiences for our clients and their customers.

We build our products with a view to productizing and scaling technology to lower the costs and reduce the risks of implementing and managing our integrated solutions. Each of our solutions starts with reliable and reputable e-commerce and MDM platforms, which run on enterprise grade infrastructure that are customized to meet a variety of client needs, situations, and budgets.  Over the next 10 years we will add new categories and capabilities that will define frictionless commerce ecosystems.

This is a journey of technology acceleration combined with consumer readiness and adoption. We are looking for people capable of adapting relentlessly to the rapidly evolving world around us.

Position Summary:

Pivotree’s IT team is searching for an accomplished Senior Database Administrator (DBA) who is highly motivated, collaborative with an entrepreneurial spirit. You will be a key member of our database team, providing input on technical decisions that will shape the company's future and most importantly, the service satisfaction of our customers. You will administer various aspects of our database administration services involving on-premise and new cloud platforms. You will join a skilled and motivated operational organization helping to build the future mode of data services for Pivotree. Remote work-from-home is available.

Roles & Responsibilities:

• Advanced in-depth knowledge of SQL Server, AWS RDS and Azure. 

• Create, maintain, and use Standard Operating Procedures (SOP?s) for migration execution and ensure long term technical viability and optimization of production deployments

• Plan, Create, Manage and Deploy Effective High Availability and Disaster Recovery strategy.

• Worked on performance comparison and optimization

• Hands on with using cloud tech tools such as AWS DMS, SMS, App Migration Service, Migration Hub, Azure Migrate, Data Migration Service, SQL Server Migration Assistant

• Migration from SQL server to/from Other RDBMS platform for PaaS models like AWS Aurora, AWS RDS, Azure SQL, OVH.

• Formulate and monitor policies, procedures and standards relating to database management.

• Provide design standards and guidance for projects and technical roadmaps.

• Capacity Planning: Forecast future database growth based on usage trends and plan for hardware and storage requirements accordingly to ensure scalability and optimal performance.

• Patch Management and Upgrades: Plan and execute SQL Server software upgrades, patches, and service packs. Stay up to date with the latest SQL Server releases and features.

• Troubleshooting and Issue Resolution: Investigate and resolve complex database-related issues, including data corruption, performance problems, and connectivity challenges.

• Automation and Scripting: Develop automation scripts and tools to streamline repetitive tasks, improve efficiency, and reduce the risk of human errors.

• Monitoring and Alerting: Set up monitoring and alerting systems to proactively identify and address potential database issues before they become critical.

• Compliance and Best Practices: Ensure that databases comply with industry standards and internal policies. Follow best practices for database management, security, and performance optimization.

• Mentoring and Training: Provide guidance and support to other  DBAs, sharing knowledge and expertise to foster their professional growth.

• Performance Analysis and Reporting: Generate performance reports and analysis for stakeholders and management to provide insights into the database environment's health and performance.

• Documentation: Maintain up-to-date documentation of database configurations, procedures, and troubleshooting steps.

• Vendor and Third-Party Tool Management: Evaluate and manage third-party tools and solutions that assist in database management, monitoring, and performance tuning. Resolve locking conflicts/blocking and resource utilization. Build tools for customers and internal teams by creating scripts or using software to automate administration tasks and DBA processes.

• Consult with customers on SQL Server including best practices and SQL Server Disaster Recovery setups.

• Participate in sales implementations vendor calls to provide advanced knowledge in the purchase of software, hardware or services that can be used to improve the performance of the database server. Carry out disaster recovery planning and execution including, log shipping, mirroring, replication, and AlwaysOn.

• Works with the product organization to assist in the roll out of new products.

• Executes large sized, complex database projects. Ensures projects are properly documented.

• Participate in 24X7 production support for SQL Server infrastructure.

• Rotational on-call 24/7 support for databases including after-hours and weekends.

Key Skills & Competencies: 

• Minimum 5+  years solid database administration experience with substantial RDBMS implementations supporting SQL Server.

• Proficient Skills in SQL Server Architecture, Installation and Configuration, Performance Tuning, High Availability and Disaster Recovery (HADR), Monitoring and Troubleshooting, Migration

• Database Migrations and Upgrades: Experience in planning and executing database migrations and upgrades, including version compatibility, testing, and minimizing downtime.

• SQL Server in the Cloud: Knowledge of deploying and managing SQL Server in cloud platforms such as Azure SQL Database and Amazon RDS.

• SQL Server Best Practices: Familiarity with industry best practices for SQL Server administration, including configuration settings, maintenance tasks, and disaster recovery strategies.

• Ability to communicate technical info and ideas so others will understand.

• Ability to apply varying leadership skills and traits that create solutions and results to unexpected situations.

• Experience working with other RDBMS like Postgresql /MySQL/ Oracle

• Experience working in AWS/Azure cloud environments.

• Demonstrated experience of resiliency practices in multi-cluster or high-availability environments in large database installations.

• Excellent communication skills, critical thinking, problem solving and sound judgment.

• Ability to work in a fast-paced and demanding environment; multitask and prioritize.

• Must be a team player with strong attention to detail and able to work independently.

• Working knowledge of Scrum/Lean and Agile, Scrum practices is desired.

• DBA certifications on SQL Server or AWS RDS/ Azure is an asset.

• University/College Degree in Computer Science, Engineering, Mathematics, or IT is an asset.

OTHER TRAITS WE LOOK FOR:

• A professionally adaptable attitude

• A positive, people-oriented and energetic attitude

• An analytical, creative, and innovative approaches to solving problems

• An interest in working hard/being challenged in a fast-paced environment, and having fun while doing it

Pivotree is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive and accessible workplace.