Doyensys is a Management & Technology Consulting company with expertise in Enterprise applications, Infrastructure Platform Support, and solutions. Doyensys helps clients to harness the power of innovation to thrive on change. The company leverages its technology expertise, global talent, and extensive industry experience to deliver powerful next-generation IT services and solutions. Doyensys Inc has operations in India, the US, Mexico, and Canada.
- Project Role: SENIOR SQL DBA
- Project Role Description: The Senior SQL DBA will be responsible for providing support for Oracle databases and Apex application. The Senior SQL DBA will work closely with the project team, stakeholders, and clients to ensure that support requests are resolved in a timely and efficient manner.As a Senior SQL DBA, you will be responsible for managing and maintaining our organization’s SQL Server databases.
- Work Experience: 8 – 10 years
- Work Location: Offshore, Day shift (EST) Night Shift (IST)
- Notice Period: Immediate or 30 days maximum
- Position: 1
Must Have Skills:
- Database Administration: Perform all aspects of SQL Server database administration, including installation, configuration, backups, restores, and upgrades.
- Performance Tuning: Monitor and optimize database performance to ensure high availability and responsiveness. Identify and resolve performance bottlenecks proactively.
- Security: Implement and maintain database security measures, including access controls, encryption, and data masking. Monitor for security breaches and take appropriate actions to mitigate risks.
- High Availability and Disaster Recovery: Configure and maintain database mirroring, clustering, and Always On Availability Groups to ensure high availability and disaster recovery readiness.
- Troubleshooting: Investigate and resolve database-related issues, such as errors, performance problems, and connectivity failures.
- Capacity Planning: Monitor database growth and plan for future storage requirements to ensure scalability.
- Automation: Develop and maintain scripts and tools to automate repetitive database administration tasks.
- Database Design: Collaborate with development teams to optimize database schema and query design for performance and efficiency.
- Documentation: Maintain comprehensive documentation of database configurations, procedures, and troubleshooting steps.
- Patch Management: Plan and execute database software patching and version upgrades while minimizing downtime and impact on services.
- Collaborate with IT Team: Work closely with system administrators, network engineers, and application developers to ensure seamless integration of databases with other systems.
- Compliance: Ensure the organization’s databases comply with relevant data protection, privacy, and regulatory requirements.
Good To Have Skills:
- Communication: Good communication skills to work collaboratively with other teams and to communicate effectively with customers.
- Soft skills: Strong interpersonal skills, including teamwork, to work effectively with stakeholders and team members.
- Provide expertise as database administrator to design, develop, and implement database solutions as needed to meet client-evolving requirements to include design, architecture, and configuration management.
- Strong understanding of MS SQL, to include Always On Availability Groups, SQL Server Failover Clusters, replication, encryption, backup, restoration and configuration techniques and concepts.
- Maintains responsibility, accountability, and credibility in all work and research assignments and sustained ability to be highly self-motivated and directed
- Documentation and Reporting: Documenting project activities and maintaining accurate records, as well as generating reports to inform management and stakeholders about project status and issues.
- Monitoring and Troubleshooting: Monitoring system health and proactively identifying and troubleshooting issues to ensure high system availability and uptime.
- Deep understanding of SQL Server architecture, internals, and best practices.
- Proficiency in performance tuning, query optimization, and troubleshooting.
- Experience with database backup and recovery strategies.
- Solid understanding of high availability (clustering, mirroring, Always On) and disaster recovery solutions.
- Familiarity with security best practices for SQL Server databases.
- Strong scripting skills (e.g., PowerShell, T-SQL) for automation and monitoring.
- Knowledge of database design principles and ability to collaborate with application developers on database schema and query optimization.
- Excellent problem-solving skills and attention to detail.
- Strong Technical Skills:SQL DBA should have strong technical skills in cloud services, networking, security, and virtualization. They should also have experience in managing and troubleshooting services, managing storage and databases, and deploying applications.
- Problem-solving Skills:SQL DBA should be able to analyze problems, identify the root cause, and develop effective solutions. They should also have experience in troubleshooting services, resolving issues, and implementing corrective actions.
- Communication Skills:SQL DBA should have excellent communication skills to effectively interact with different stakeholders such as team members, clients, and management. They should be able to communicate technical information in a clear and concise manner.
- Time Management Skills:SQL DBA should be able to manage their time effectively to meet deadlines, prioritize tasks, and work on multiple projects simultaneously. They should also be able to work under pressure and manage their workload efficiently.
- Attention to Detail:SQL DBA should have a strong attention to detail and be able to perform tasks accurately. They should also be able to document their work clearly and comprehensively.
- Team Player:SQL DBA should be able to work well in a team environment and collaborate effectively with other team members. They should also be open to learning new skills and sharing their knowledge with others.
- Customer Service Skills:SQL DBA should have excellent customer service skills to interact with clients, understand their requirements, and provide effective solutions to their problems. They should also be able to provide timely and professional support to clients.
- Bachelor’s degree in Computer Science or a related field
- Understanding of cloud security best practices
- Excellent problem-solving and troubleshooting skills
- Strong communication and collaboration skills
- Ability to work independently and as part of a team
- Willingness to learn and adapt to new technologies and practices
- Attention to detail
- Strong problem-solving skills
- Ability to work in a team
- Strong communication skills
- Ability to learn and adapt
- Time management skills
- Customer focus
- Flexibility and adaptability