Doyensys Job Description - SQL - DBA

About Doyensys:
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.
Job Requirement
 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
Technical Expertise
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.
 Key Responsibilities:
 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.
Professional Attributes:
 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.
Educational Qualification:
 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
Behavioral Attribute:
 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
 Initiative
 Professionalism

Doyensys Job Description - SQL - DBA

Uploaded by

Copyright:

Available Formats

Doyensys Job Description - SQL - DBA

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Doyensys Job Description - SQL - DBA

Uploaded by

Copyright:

Available Formats

About Doyensys:

 Project Role: SENIOR SQL DBA

 Work Experience: 8 - 10 years

Must Have Skills:

 Documentation: Maintain comprehensive documentation of database configurations,

 Good To Have Skills:

 Maintains responsibility, accountability, and credibility in all work and research

 Bachelor's degree in Computer Science or a related field

You might also like