5+ years of overall hands-on experience proven experience in writing complex stored procedures, packages, functions, and triggers.
Experience in handling large volume of data with server/client-side coding , along with good knowledge of cursors and advanced bulk collection concepts.
Experience in monitoring and performance tuning of databases on Cloud (Public, Private, Hybrid)
Proven experience in remediating the server/client-side code migrating enterprise level database from On-premise to On-premise /Cloud (Public, Private, Hybrid)
Experience in heterogenous database migration (Sqlserver to PostgreSQL/ MySQL, Sybase to SQL Server, Oracle to PostgreSQL, etc.). Well-versed in all data-types, and data-type conversion.
Strong experience in writing SQL queries, with hands on exp of performance tuning, ensuring the stability, reliability, performance of the DB, and handling DB drivers/linked servers.
Maintaining data quality data security - encryption at-rest in-transit, hashing, masking, integrity constraints.
Participates in or leads a database migration team supporting one or more application projects which must be migrated from on-premise to AWS/Azure/GCP cloud environment.
Works collaboratively with the application team, including architects, developers, DBA and testers to ensure project success.
Good knowledge in creating and managing database schemas and schema objects like tables, indexes, partitions and dictionaries.
Should be able to understand complex business requirements and existing relational data models, and archive methods.
Knowledge and expertise in database consolidation , de-consolidation , and database archive.
Knowledge and expertise in using different database performance tools
Experience in heterogenous DB migration to cloud
Experience in writing SQL queries, procedures, functions etc.
Performance tuning of queries
T-SQL, and PowerShell
Very strong written and oral communication skills
Good communication and interpersonal skills
Managing day-to-day operation activities
Experience with JIRA issue tracking tool
DB Migration tools
Performance tuning; Coding; Postgresql; MySQL; Stored procedures; Oracle; microsoft; JIRA; SyBase; Monitoring
DXC is the worlds leading independent, end-to-end IT services company, helping clients harness the power of innovation to thrive on change. Created by the merger of CSC and the Enterprise Services business of Hewlett Packard Enterprise, DXC Technology is a $25 billion company with a 60-year legacy of delivering results for thousands of clients in more than 70 countries. Our technology independence, global talent and extensive partner network combine to deliver powerful next-generation IT services and solutions.