Database Administrator

작업 내용

Merilytics offers advanced and intelligent analytical solutions to clients globally. Our solutions primarily focus on using decision sciences and analytics-based approach to generate superior returns for clients.

For more information about the company, please visit us at www.merilytics.com

Responsibilities:

• Performs all database administration tasks required to design, implement, manage, and support 24x7 production environments with Microsoft SQL Server, Azure SQL, and other RDBMS databases.
• Drives incident response, root cause analysis, and advanced performance troubleshooting to proactively resolve database infrastructure problems and isolate application defects.
• Works closely with Development, QA, Support, and Implementation teams across the full SDLC to design databases, queries and maintenance plans for availability and performance.
• Develops and tests complex stored procedures and recommends optimizations.
• Creates scripts to automate data collection and database administration tasks.
• Builds and optimizes reports using SQL Reporting Services, Power BI, Crystal Reports, and other reporting and analytics tools.
• Defines and manages maintenance plans for non-production and production environments.
• Ensures security requirements are met, supports audit and compliance activities, and manages end-to-end encryption of data at rest.
• Proactively monitors the database and query performance using native and third-party tools.
• Performs installation, configuration, and patching of database server instances.
• Architects solutions for workloads that optimally leverage bare metal, virtualization, active/active clustering, and other approaches to meet BC/DR plans and RTO/RPO targets.
• Leads engagements with internal customers, external clients, and auditors as an SME on Microsoft SQL Server technologies (database, analysis, integration, and reporting services) including SSIS, SSRS and SSAS.

Skill Requirements:

• Bachelor’s Degree in Computer Science, Information Systems, or a related field from tier/tier-II colleges
• 3-8 years of experience managing Microsoft SQL Server technologies across the full SDLC.
• 3-8 years of experience supporting databases in 24x7 production environments.
• Experience designing, building and managing database environments to meet RTOs/RPOs and BC/DR requirements via clustering, virtualization, log shipping, etc.
• Experience planning, implementing and managing virtualized database servers in a VMware vSphere or Microsoft Hyper-V environments. Azure SQL PaaS experience is a plus.
• Proficient in T-SQL and/or PL/SQL. PowerShell and/or shell scripting experience is a plus.
• Experience working in consulting or other high-growth, fast-paced agile environments where technology is leveraged as an asset to drive culture, quality, and velocity.
• Able to adhere to technical standards that augment security and infrastructure architecture.
• Ability to strongly influence peers and technical staff within the team.