Sr. SQL Database Developer/Performance Analyst

  • Full-time

Company Description

WNS Global Services Inc. (NYSE: WNS) is a global Business Process Management (BPM) leader. WNS offers business value to 400+global clients by combining operational excellence with deep domain expertise in key industry verticals, including Banking and Financial Services, Consulting and Professional Services, Healthcare, Insurance, Manufacturing, Retail and Consumer Packaged Goods, Shipping and Logistics, Telecommunications, Travel and Utilities. Globally, the group’s over 44,000+ Professionals serve across 60 delivery centers in 16 countries worldwide.

WNS Philippines - Established in 2008, WNS Philippines has been delivering the full spectrum of BPM services – in customer interaction services, finance and accounting, research and analytics, technology solutions and industry-specific businesses for more than 10 years. With more than 8,000 employees spread across 11 sites located in 4 key cities, Quezon City, Pasig City, Muntinlupa City, and Iloilo City – WNS is one of the fastest growing centers in the country.

Why Join Us?

At WNS, our mission is to enable clients to outperform with our passion for service and innovation. At the heart of each client engagement is our pursuit to understand our client’s business, and create impactful solutions that can drive agility and excellence into their business processes. Our promise of outperformance stems from our deep domain expertise, partnership approach and a global delivery network.

Our mission as an organization is guided by our CIRCLE of values: Client First, Integrity, Respect, Collaboration, Learning, Excellence.

We promise our employees to experience role clarity, coaching and mentoring, professional development and structured career path through our 5 people promises and keeping employee experience at the core. Experience the culture of outperformance, engagement, celebration and enjoy wide variety of best in class benefits including free HMO coverage for self and dependent from Day 1; Also contribute to society through our WNS Cares Foundation, where you have the opportunity to support meaningful initiatives and make an impact in the community.

Job Description

MAJOR RESPONSIBILITIES

·         Hands on and excellence in writing T-SQL complex scripts,  stored procedures, database functions, CLR integration, report writing, best practices (optimization, use of joins and sub-queries), design and develop ETL processes utilizing SSIS, complex ETL mappings and other database activities (archive, backups, recovery etc.).

·         Handle data-centric project life cycle development and methodology to plan, design, build, transform, test,  store  & maintain data on data platform, optimize data-centric projects, increasing awareness of data definitions, maintain consistent data standard across different database systems.

·         Handle production data systems support - critical applications, day to day tasks/incidents, troubleshooting sensitive data issues, data deployment, change request, monitoring production jobs & data processes, etc.

·         Troubleshoot and resolve any database related issues (performance/waits/bottlenecks/deadlocks, connectivity, backups, security, AAG, and environment).

·         Assist with managing and monitoring multiple mission critical SQL Server environments, mostly running with SQL Server 2016.

·         Research & Develop new and improved strategies and processes to help enhance the data environment.

·         Perform new installations and upgrades to existing SQL Server instances.

·         Handle tracing the application slowness, identifying root cause and resolving the problem in live system.

·         Understand schemas, table indexing and statistics, partitioning, query strategies, and database objects maintenance and performance issues.

·         Maintains database performance by identifying and resolving production and application development problems; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.

·         Analyze and monitor existing systems capabilities, automate data solutions, implement best practices for data movement across ETL, database/ data warehouse and ensure that the data is adherence to Health care standards, policies, compliance and any external regulations. Working with external data auditors (SOX, Risk Mgt, IT InfoSec) to ensure compliance is met.

·         Ability to manage individual priorities, coordinate with team members / other departments to address their data/database issues, requirement gathering, drafting technical documents, develop & deploy new data solutions by performing unit, integration, acceptance testing and bug fixing etc.

·         Monitoring Database and Reporting Server using tools such as AppDynamics, SolarWinds, RedGate or some custom scripts to collect database metrics and come up with a solution to address the problems proactively.

·         Performance tuning in mission critical environments. Perform analysis using Extended Events/Profiler, execution plans, DMVs, system tables, error logs, data/plan caches, etc.)

·         Good interpersonal skills, ability to work and collaborate with business and other departments to collect new requirements and design the system with Database administrators, Data Architects and DB Systems managers within the organization.

·         Any other relevant tasks necessary by company

Qualifications

MAJOR RESPONSIBILITIES

·         Hands on and excellence in writing T-SQL complex scripts,  stored procedures, database functions, CLR integration, report writing, best practices (optimization, use of joins and sub-queries), design and develop ETL processes utilizing SSIS, complex ETL mappings and other database activities (archive, backups, recovery etc.).

·         Handle data-centric project life cycle development and methodology to plan, design, build, transform, test,  store  & maintain data on data platform, optimize data-centric projects, increasing awareness of data definitions, maintain consistent data standard across different database systems.

·         Handle production data systems support - critical applications, day to day tasks/incidents, troubleshooting sensitive data issues, data deployment, change request, monitoring production jobs & data processes, etc.

·         Troubleshoot and resolve any database related issues (performance/waits/bottlenecks/deadlocks, connectivity, backups, security, AAG, and environment).

·         Assist with managing and monitoring multiple mission critical SQL Server environments, mostly running with SQL Server 2016.

·         Research & Develop new and improved strategies and processes to help enhance the data environment.

·         Perform new installations and upgrades to existing SQL Server instances.

·         Handle tracing the application slowness, identifying root cause and resolving the problem in live system.

·         Understand schemas, table indexing and statistics, partitioning, query strategies, and database objects maintenance and performance issues.

·         Maintains database performance by identifying and resolving production and application development problems; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.

·         Analyze and monitor existing systems capabilities, automate data solutions, implement best practices for data movement across ETL, database/ data warehouse and ensure that the data is adherence to Health care standards, policies, compliance and any external regulations. Working with external data auditors (SOX, Risk Mgt, IT InfoSec) to ensure compliance is met.

·         Ability to manage individual priorities, coordinate with team members / other departments to address their data/database issues, requirement gathering, drafting technical documents, develop & deploy new data solutions by performing unit, integration, acceptance testing and bug fixing etc.

·         Monitoring Database and Reporting Server using tools such as AppDynamics, SolarWinds, RedGate or some custom scripts to collect database metrics and come up with a solution to address the problems proactively.

·         Performance tuning in mission critical environments. Perform analysis using Extended Events/Profiler, execution plans, DMVs, system tables, error logs, data/plan caches, etc.)

·         Good interpersonal skills, ability to work and collaborate with business and other departments to collect new requirements and design the system with Database administrators, Data Architects and DB Systems managers within the organization.

·         Any other relevant tasks necessary by company

 

QUALIFICATIONS & REQUIREMENTS

·         Bachelor's degree in computer science engineering, mathematics, information technology, Business Administration required Or Master Degree in computer science, computer application or Business Administration required. A combination of education and experience will also suffice.

·         Minimum 5+ years of extensive experience in, Data & Database Management, High availability strategies - Server Always On Availability Groups, data replication and failover, Security and Permissions, Indexing/Statistics maintenance and strategies, Setup and Configuration of SQL Servers, Encryption and Data Masking,   Strong technical problem solver in high pressure situations.

·         Experience with relational database systems in an operational environment and particularly with Microsoft SQL Server 2012 or later.

·         Experience in multi-server data management and database administration functions, Performance tuning in mission critical environments. Perform analysis using execution plans, DMVs, system tables, error logs, etc.

·         Experience in data-centric project life cycle development and methodology to plan, design, build, transform, test,  store  & maintain data on data platform, optimize data-centric projects, increasing awareness of data definitions, maintain consistent data standard across different database systems.

·         Table Partitioning. Source code versioning, SQL Server Integration Services (SSIS)  and other equivalent ETL tools and ETL design and development & T-SQL programming using SQL Server 2017/2016/2014/2012.

·         Excellent work ethic, organizational, analytical, planning, problem solving, and communication skills are must

·         Must be authorized to work in the United States on a full-time basis for any employer

·         Microsoft Certification (MCSA/MCSE) is a plus.

Additional Information

All your information will be kept confidential according to EEO guidelines.

Privacy PolicyImprint