Sr Systems Engineer


  • Company:
    Bank of America
  • Location:
  • Salary:
    negotiable / month
  • Job type:
    Full-Time
  • Posted:
    2 months ago
  • Category:
    Banking

Skill: information technology , disaster recovery , global delivery , technology infrastructure , windows os , query optimization , database creation , database servers , database maintenance , sql server dba , patching , sql , database; Exp: 3-6 years; Sr Systems Engineer Gurugram, India Job number 18063357 Job Description Overview * (Bank of America overview, BA Continuum India overview, Business Overview) Bank of America is one of the world’s largest financial institutions, serving individual consumers, smalland middle-market businesses and large corporations with a full range of banking, investing, asset management and other financial and risk management products and services. BA Continuum is a nonbank subsidiary of Bank of America, part of our Global Delivery Center of Expertise in the bank. Our employees help our customers and clients at every stage of their financial lives, helping them connect to what matters most. This purpose defines and unites us. Every day, we are focused on delivering value, convenience, expertise and innovation for the individuals, businesses and institutional investors we serve worldwide. We are committed to attracting and retaining top talent across the globe to ensure our continued success. Along with taking care of our customers, we want to be the best place for people to work and aim at creating a work environment where all employees have the opportunity to achieve their goals. BA Continuum India Pvt. Ltd. supports business process, information technology and knowledge process across Consumer Banking, including Card and Home Loans, Legacy Asset Servicing, Global Banking and Markets, and Global Wealth and Investment Management lines of business at Bank of America. Process Overview* Chief Technology Organization (CTO), part of the Global Technology & Operations organization, consists of more than 6,600 employees worldwide. With a presence in more than 35 countries, CTO designs, builds and operates end-to-end technology infrastructure solutions and manages critical systems and platforms across the bank. CTO delivers industry-leading infrastructure products and services to the companys employees, customers and clients around the world. Job Description* Individual will be part of the SQL Server DBA Support Team and will provide support for all SQL Server infrastructure in Bank. This process provides Change releases, break fix , Automations, Operations and Design & Build support for SQL Servers . The process is responsible for performing all Operations & Break Fix and Design & Build activities which includes SQL Server Database Administration, support and Remediation. Individual will perform complex operational tasks that include monitoring of various types of applications used in a web infrastructure, evaluation and diagnosis of production,non-production system alerts, analyzing root cause of any problem issues, resolving all database server problems in the production and the non-production environments. Responsibilities* Monitors and tunes the database servers to achieve optimum performance levels. Provide support for planned disaster recovery tests and all maintenance activities. Provide support for Break fix, Production and Non Production releases. Optimize the performance of SQL Server infrastructure and codeQuery. Provide 16*7 coverage support for all environments. Monitoring all engagement queues belonging to CTO SQL Server Operations support and take action on all requests/alerts. Perform review of all production related changes and verify after modifications. Restoration of data for the Business as per the requirement. Configure automation jobs and ensure all maintenance jobs executed successfully. Vendor co-ordination to troubleshoot issues like tape backup, database bugs. Provide support for planned disaster recovery tests and all maintenance activities. Perform new database builds Perform database patching and version upgrades Support performance tuning requests Perform monitoring tool deployment and maintenance Participates in Capacity planning and Infrastructure baselining. Support database releases in production and non-production environments Support Centralized Access Management requests for user provisioning Provide 16*7 coverage support for all environments. Requirements* Candidate should have knowledge in SQL Server technology At least 3 years relevant experience providing SQL Server DBA support in medium to large environments. Experience in SQL Server Troubleshooting, Performance Tuning and Query Optimization Experience in implementing SQL Server High Availability solutions Experience in SQL Server Integration, Reporting and Analysis Services Experience in database creation, database restores and database maintenance tasks Experience in Performing Database disaster recovery design and implementation Strong knowledge on database sizing, design, optimization Knowledge and experience in Powershell or MS.NET or similar Scripting would be advantage. Should have Knowledge in ITIL process Should be flexible for Shifts and weekend coverage. Interpersonal sensitivity and customer responsiveness with good spoken and written communication skills. Education* BE/BTECH/MCA/ME/MTECH Certifications If Any Microsoft SQL Experience Range* 2-6 years Mandatory skills* MS SQL Administration Basic Windows OS Desired skills* MS.NET / PowerShell/Python Work Timings* 16*7 shift window, Should be flexible with rotational shifts Job Location* – Gurugram * Mandatory Fields Posting Date 25/10/2018 Location SECTOR 21 DUNDAHERA – TOWER – A, BUILDING – 8 – India Full / Part-time Full time Hours Per Week 45

Database Administration (DBA)

Degree: MCA/ PGDCA

Experience: 3-6

Function: IT Software : Software Products & Services