VI
Senior Database administrator
VARITE INDIA PRIVATE LIMITED
- ๐ฎ๐ณ India
- On-site
- Senior
- 10 months ago
- Salesforce
- Adobe
- AWS
- Agile
- Scrum
- Kanban
- Azure
- CI/CD
- Microsoft SQL Server
- PowerShell
- T-SQL
- SSIS
- SSRS
- Disaster Recovery
- SQL
- Incident Management
- ETL
- C#
- Git
- TeamCity
- Devops
10 months ago
About The Client:
Visionet is a premier digital technology solutions company built on the premise of disruptive innovation. For over 27 years, our innovation-centric and engineering-first approach has unlocked digital-driven success to over 350+ global enterprises across Client, Retail, Banking & Financial Services, Food & Beverage, Manufacturing & Distribution, and Life Sciences industries. Our strategic technological alliances with Microsoft, Google, Salesforce, Adobe and AWS, as well as accolades like Microsoft Partner of the Year 2021 and EY Entrepreneur of the Year 2021, are a testament to our expertise in delivering seamless digital transition. With a talent pool of more than 9,500 passionate engineers and digital consultants across 14 distinct locations around the world, we engineer agility and provide innovation-driven value to our clients.
About The Job:
- As a Senior Database administrator you will be working in a maturing agile team, following Scrum/Kanban practices and responsible for maintaining high availability on all current and legacy database technologies, whilst collaborating with the various teams to review designs and potential to be involved in supporting new data solutions based on Azure and other public cloud providers.
- To develop and maintain CI/CD database code to support Beazley applications and IT/DBA utilities.
- Demonstrate to a high standard the knowledge and ability to administer Microsoft SQL Server database servers and AlwaysOn instances in a multi datacentre and hybrid enterprise IT environment, to develop and troubleshoot PowerShell/TSQL code, SSIS packages, SSRS and PBI reports.
- Common responsibilities will include database design reviews, data integrity checks, data security compliance, business continuity, database availability, enterprise database management, process and policy improvements, database performance monitoring, right sizing, incident/problem management, self-healing and automation procedures using DBA tools including schema design, stored procedures, functions, views, SSIS, SSAS, PBI and SSRS.
- As normal in an IT operational environment, projects and problems may demand evening and weekend coverage. This will be scheduled in advance as far as possible
Production database responsibilities will include:
- instance installation and configuration, database creation and sizing
- implement and refine Beazley database security standards, identify and report issues and vulnerabilities and work to mitigate these, provide mechanisms to protect private, confidential, and sensitive data
- ensure data integrity and business continuity, participating in annual Beazley disaster recovery testing, implement and help refine database maintenance tasks
- performance tuning to meet or exceed agreed quality of service and database performance targets, maintain maximum uptime and ensure high availability for business critical SQL Servers and Hadron clusters
- assist in incident management, problem resolution and continuous process improvement
- follow the Beazley change control process
- provide support to production application maintenance teams
- configure, maintain and enhance the development, staging, UAT, packaging and maintenance database environments, with production restores and implementing appropriate security
- maintain and publish database development standards, enforce the use of standards, best practice and change control within the teams
- provide database support for project planning and development projects
- develop and maintain database schemas and code using triggers, defaults, constraints, views, stored procedures, scalar and table valued functions, CLR, linked servers, openquery and service broker
- develop reports using SSRS, jobs using SQL Agent and ETL with TSQL and C# using SSIS
- Support and Build to CI/CD database projects using GIT/TeamCity/Octopus devops tools
- Deliver solutions to complex technical database issues
- Assist in the implementation of new technical initiatives, evaluate new versions, features and tools
- To comply with relevant IT and Beazley group procedures and policies.
- Taking an agile approach to prioritised and allocated tasks so that ceremonies run smoothly and deliverables are met
- Experience: 7-10 Years
Unlock Rewards: Refer Candidates and Earn.
If you're not available or interested in this opportunity, please pass this along to anyone in your network who might be a good fit and interested in our open positions. VARITE offers a Candidate Referral program, where you'll receive a one-time referral bonus based on the following scale if the referred candidate completes a three-month assignment with VARITE.
Experience Level Bonus Referral:
| 0-2 years | INR 5,000 |
| 2-6 years | INR 7,500 |
| 6+ years | INR 10,000 |
About VARITE: VARITE is a global staffing and IT consulting company providing technical consulting and team augmentation services to Fortune 500 Companies in USA, UK, CANADA and INDIA. VARITE is currently a primary and direct vendor to the leading corporations in the verticals of Networking, Cloud Infrastructure, Hardware and Software, Digital Marketing and Media Solutions, Clinical Diagnostics, Utilities, Gaming and Entertainment, and Financial Services.
Equal Opportunity Employer:
VARITE is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, marital status, veteran status, or disability status.
Senior Database administrator ยท VARITE INDIA PRIVATE LIMITED