
SQL Database Administrator
Protera
full-time
Posted on:
Location Type: Remote
Location: India
Visit company websiteExplore more
About the role
- The Database Administrator is responsible for all aspects of database administration, configuration, monitoring, and deployment of Microsoft SQL databases and database build packages in the Production environment as well as other non-production environments.
- Collaborate with internal and external teams to optimize and update database operations and ensure continuous improvement in monitoring and performance.
- Performs all work in accordance with company’s quality programs, standards and procedures.
- Provides technical leadership to the development team in resolving development and implementation issues related to the database infrastructure.
- Responsible for participation in determining strategic architecture direction.
- Review technical documents to ensure consistency, accuracy and compliance with enterprise directions and security standards.
- Devise plans for patching and upgrading the database infrastructure.
- Develop and maintain all standards pursuant to data structures and models, review data models and frameworks/blueprints.
- Responsible for performing routine maintenance tasks, such as database backups, index rebuilding, and statistics gathering.
- Responsible for performance tuning of data retrieval and data loading program units.
- Responsible for capacity planning and performing Volumetric Analysis.
- Work with clients, business analysts, technical staff, and project team members to plan, design, develop, implement, and enhance applications, scripts, procedures, and metadata for relational databases.
- Provides full-life cycle product roadmaps for the database infrastructure.
- Reviews operational data structures and recommends optimizations and reconfigurations as warranted.
- Identify potential strategic data-related technology partners, evaluate and/or assess potential data-related tools and technologies.
- Work closely with 3rd party vendors to integrate selected packages. Recommend and evaluate new tools and methodologies.
- Conduct proof of concept and evaluate new features available for Microsoft SQL or related Database technologies and perform cost benefit analysis as applicable.
- Maintain safety, security, and privacy standards throughout all areas of responsibility.
- Develop and implement data security policies, procedures, and best practices to protect sensitive information.
Requirements
- Proficient in Microsoft Office products, including but not limited to: Microsoft Word, PowerPoint, Excel, Outlook, and Visio.
- 4+ years of experience with all aspects of SQL Server and AOAG build, configuration, and deployments.
- Experienced in RDBMS administration and configuration for large projects.
- Prefer knowledge of XML standards.
- Excellent verbal and written communication skills.
- Ability to think critically and problem solve using industry standard methodologies.
- Ability to manage time and multiple priorities.
- Ability to document and update standard operating procedures.
- Disciplined, detail-oriented, and well organized with a strong background in operational methodology.
- Ability to interface and work with varied positions and levels of technical knowledge both within the department and with other departments in the company.
- Solid analytical and troubleshooting skills to quickly determine root causes of problems and drive towards solutions.
- Must foster a collaborative and collegial atmosphere within a dynamic and fast-paced work environment.
- Bachelor's degree in Computer Science, Information Systems, or other related field, or equivalent work experience.
- 5+ years of experience as an MS SQL or equivalent Database administrator in a clustered AOAG environment.
Benefits
- Work from Home set up
- Comprehensive medical benefits
- Gratuity, PF, EPS and Bonus
- Shift Allowances
- Health and wellness Allowances
- Learning and Development Allowances
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
Microsoft SQL ServerRDBMS administrationAOAG builddatabase configurationdatabase deploymentperformance tuningdata retrievaldata loadingXML standardsdata security policies
Soft Skills
verbal communicationwritten communicationcritical thinkingproblem solvingtime managementorganizational skillsanalytical skillstroubleshooting skillscollaborationattention to detail