IN | SSIS

Job Description

Description Maintains the ongoing operaensuring system performance availability reliability security recoverability change management regulatory compliances and efficient usage of server infrastructure resources. Performs the capacity planning required to build and maintain corporate databases to meet the processing demands. Provides database solutions to solve complex business issues including data processing loading performance improvements data storage and data replication. Diagnoses troubleshoots and resolves database related issues including storage performance availability data integrity and database security. Performs and automates database management maintenance and data processing activities. Develops scripts to perform system maintenance monitor systems automate tasks etc. Documents processes related to database design configuration standards and performance. Creates modifies maintains and optimizes database objects such as indexes tables partitions triggers constraints stored procedures large objects views etc. Works as part of a project team to coordinate database development and determine project scope and limitations. Evaluates business needs and objectives performs feasibility analysis requirements analysis and estimates work effort of project deliverables and trains users. Determines user accounts and audits user access levels for each segment of database and grants access appropriately. Experience deploying SQL Server in AWS and Azure and experience with RDS Azure Managed Instances Evaluates releases of MS SQL Server and its tools and third-party products to ensure that the organization is running the products that are most appropriate. Collaboration with various technical/non-technical resources such as infrastructure and application teams regarding project work POCs (Proofs of Concept) and/or troubleshooting exercises. Analyzes Operating System statistics and troubleshooting performance related problems on storage I/O (Input/Output) throughput and OS (Operating System) kernel parameters. Quickly adapt new automation technologies and implement the same. Instrument APM Monitoring tools. Participate in 24/7 on-call rotation and escalate issues as needed. Perform other job related duties as assigned. Named Job Posting? (if Yes - needs to be approved by SCSC) Additional Details Global Grade B Level To Be Defined Named Job Posting? (if Yes - needs to be approved by SCSC) No Remote work possibility Yes Global Role Family 60236 (P) Software Engineering Local Role Name 6504 Developer / Software Engineer Local Skills 4710 MS SQL Server - SSIS Languages RequiredEnglish Role Rarity To Be Defined