Job Description

SQL Administrator (On-Contract)
===================================

Functional area: Information Technology
Country: India
City: Maharastra
Company name: Edwards India Private Ltd
Date of posting: Oct 16, 2024
Operations:


• SQL services and databases installation and configuration: installing and configuring new SQL services on our central SQL clusters or Azure SQL managed Instances.
• Migrate SQL databases after Business alignment to Azure SQL Managed instances
• Document migration process and coordinate actions with the VTIS Business Application team and / or VTIS Server Cloud team
• Database maintenance and support: must ensure that the SQL databases and services are up to date and are functioning properly
• Security and compliance: ensuring that the SQL databases meet security and compliance standards
• Data Quality: Ensure that the CMDB documentation is up to date for all VTBA SQL databases
• Ensure that SQL database projects stay on track.
• Co-ordinate with vendor and the business to install / fix an database issue
• Maintain high availability and performance of SQL databases
• Ensure the security of SQL database by implementing best practices and adhering to organizational security policies.
• Coordinate database updates and security issues with all parties and business
• Keep the VTBA SQL database on prem and cloud landscape modern and clean
• Consult and Support VTBA for new SQL databases
• Stay updated with new trends and technologies to continually improve the organization's software stack.


Project work:


Assessment & Planning


• Inventory Database Assets: Identify all SQL databases that need to be migrated, including their size, dependencies, and configurations.
• Assess Compatibility: Check for compatibility between your current on-premise SQL system and the cloud provider's database services.
• Migration Strategy: Define a migration strategy (e.g., rehosting, re-platforming, or refactoring). You can choose between a lift-and-shift (move as is) or modernization (optimizing for the cloud) approach.
• Data Governance: Evaluate compliance, security, and data residency regulations.


Preparation


• Database Sizing and Capacity Planning: Estimate the required cloud infrastructure, considering performance and scaling needs.
• Plan and prepare Data migration from MySQL, MongoDB and Oracle XE to Azure SQL Managed instance
• Schema & Data Cleanup: Optimize and clean up database schemas, removing unused objects, tables, and data.
• Backup and Recovery Plan: Establish a robust backup and recovery strategy before starting the migration.


Setting Up Cloud Environment


• Provision Cloud Infrastructure: Set up your cloud environment, including database instances, storage, networking, and compute resources.
• Security Setup: Implement security best practices, such as encryption, access control (IAM roles), SSL/TLS for data in transit, and data encryption at rest.


Data Migration


• Data Transfer Options: Choose the best migration method:
• Online Migration: Migrate while the current system is live (minimizes downtime).
• Offline Migration: Migrate during a planned downtime window.
• Data Synchronization Tools: Use cloud migration tools (e.g., Migration Service, Azure Database Migration Service).
• Full Database Migration: Migrate the entire SQL database, including schema, indexes, stored procedures, and triggers.
• Incremental Data Migration: Perform delta migrations for any data changes during the migration indow.
• Schema & Object Conversion: Convert database objects, data types, and code (if necessary) to be compatible with the target cloud environment.


Testing & Validation


• Data Integrity Testing: Verify that all data has been migrated correctly and without corruption.
• Performance Testing: Ensure that the migrated database performs as expected in the cloud environment, conducting stress tests and load tests.
• Application Testing: Test all associated applications to ensure they work properly with the cloud database.
• Security Testing: Validate that access control and encryption settings are functioning correctly.
• Backup & Disaster Recovery Testing: Ensure backups are taken correctly and that disaster recovery procedures work in the cloud.


Cutover & Go-Live


• Finalize Data Migration: Complete the final incremental data migration to ensure all changes during the migration process are captured.
• Switch Production Traffic: Redirect application traffic from the on-premise database to the cloud database.
• Monitor Operations: Closely monitor database performance and application behavior during the initial days of cloud operations.
• Decommission Legacy Systems: After ensuring everything is running smoothly, decommission the on-premise systems (if applicable).


Post-Migration Optimization & Management


• Performance Tuning: Continuously optimize the database for cloud performance (e.g., adjusting indexes, partitions, etc.).
• Scaling & Auto-scaling: Set up auto-scaling policies for your cloud resources to handle traffic fluctuations.
• Cost Management: Monitor and manage cloud costs, using tools provided by the cloud provider to optimize resource usage.
• Regular Backups & Patching: Set up automated backup policies and ensure regular updates or patching of the database services.
• Security Auditing: Regularly audit cloud security settings, including IAM roles and data encryption policies.


Documentation & Knowledge Transfer


• Document the Migration Process: Maintain detailed documentation on the migration process, configurations, and challenges faced.
• Training: Train your team on managing the new cloud-based SQL environment, covering monitoring, scaling, security, and cost management.






Project Management and Technical Assistance




• Attend projects and realize new features
• Collaborate with project managers and business users
• Participate in data quality efforts and in architecture design
• Update on weekly base the progress report for VTBA infrastructure projects
• Define with the project lead how to measure project progress
• Attend project meetings and ensure that project progress is noted and reported




IT Security

Follow VTBA IT Policies


• Inform the IT security officer and Head of IT about security breaches






Maintains consistent interfaces with




• End users VTBA
• IT colleagues VTBA IT
• VT BA project teams
• VT BA Global IM Service Desk
• Group IT SAP team
• External service providers like Kyndryl and SAP


Diverse by nature and inclusive by choice

Bright ideas come from all of us. The more unique perspectives we embrace, the more innovative we are. Together we build a culture where difference is valued and we share a deep sense of purpose and belonging.