This job is no longer accepting applications
It closed on 7 Jun 2024. Here are 6 live jobs like it - apply in one step.
Apply nowApply
Wealth Management - GS Family Office - Analyst- BengaluruApply nowApplyGoldman SachsBengaluru, Karnataka · 2-5 yrs · Posted 13 days ago
IT Analyst (SAP SPP) - ReturnshipApply nowApplyCaterpillar Inc.Bengaluru / Bangalore, Karnataka · 3-5 yrs · Posted today
Senior Analyst – Order Management & Customer ServiceApply nowApplyDiageoBengaluru / Bangalore, Karnataka · 0-1 yrs · Posted 24 days ago- Senior Analyst - Vulnerability ManagementApply nowApplySociete Generale Global Solution CentreBengaluru / Bangalore, Karnataka · 5-7 yrs · Posted 18 days ago
Business Analyst - Capital Market (Derivatives/Fixed income/Equity)Apply nowApplyCapcoHybrid - Bengaluru, Mumbai (All Areas) · 5-10 yrs · Posted 12 days ago
Job Description
You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. Youll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, youll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do. Discover how you can make a difference in the lives of individuals, families and communities around the world.
:
Analyst Development SQL DBA
- Are you ready to shine?
- At Sun Life, we empower you to be your most brilliant self.
- Who we are?
Sun Life is a leading financial services company with history of 150+ years that helps our clients achieve lifetime financial security and live healthier lives.
To do this, we offer a broad range of protection and wealth products and services to individuals, businesses, and institutions, including:
- Insurance. Life, health, wellness, disability, critical illness, stop-loss, and long-term care insurance.
- Investments. Mutual funds, segregated funds, annuities, and guaranteed investment products
- Advice. Financial planning and retirement planning services
- Asset management. Pooled funds, institutional portfolios, and pension funds
With innovative technology, a strong distribution network and long-standing relationships with some of the world’s largest employers, we are today providing financial security to millions of people globally.
Sun Life is a leading financial services company that helps our clients achieve lifetime financial security and live healthier lives, with strong insurance, asset management, investments, and financial advice portfolios. At Sun Life, our asset management business draws on the talent and experience of professionals from around the globe.
Sun Life Global Solutions (SLGS)
Established in the Philippines in 1991 and in India in 2006, Sun Life Global Solutions, (formerly Asia Service Centres), a microcosm of Sun Life, is poised to harness the regions’ potential in a significant way - from India and the Philippines to the world. We are architecting and executing a BOLDER vision: being a Digital and Innovation Hub, shaping the Business, driving Transformation and superior Client experience by providing expert Technology, Business and Knowledge Services and advanced Solutions. We help our clients achieve lifetime financial security and live healthier lives – our core purpose and mission.
We strive to Shine Together, Make Life Brighter & Shape the Future!
What will you do?
- 2.5 – 5 Years of experience to be a part of Database administrator team with proficiency in SQL and Oracle DB
- Database Administrative support of SQL Server: Monitoring, maintenance and housekeeping of SQL Server and Databases, SQL Jobs. Writing and tuning SQL codes and highly customized jobs.
- Infrastructure support of SQL Server: server/instance installs (stand-alone and clustered), service-pack upgrades, hot fixes, client tool installs, readiness programs.
- BI support of SSIS and SSRS: Deployment, Security, performance tuning, Creating and enforcing Standards & best practices, troubleshoot and diagnose issues with SSIS, SSRS.
- Support of application and upgrade database (Database Migration/ upgrade) from existing SQL versions to latest SQL Server versions.
- Communicate and collaborate effectively with peer DBAs and application/infra teams.
- Monitor database performance and identify bottlenecks.
- Document database environments. Maintain records of database configurations, permissions, backups, and other details.
- Should be flexible to support Nightly batch/On-call/Weekend Upgrades, Implementations and rostered Night shift if required.
- Role Definition:
- I Design and development delivery within projects that is efficient, functional, and maintainable.
- Apply analysis skills to understand and assess the impact of infrastructure and technical changes within the environment.
- I will create required design and development documentation and participate in both design and code reviews.
- I understand the software requirements and ensure it’s translated into good quality production - ready code basis provided design & instructions.
- I understand the defined scope and timelines and deliver quality deliverable within the estimated time.
- I attend and actively participate in the team ceremonies.
- TECHNICAL SKILLS
- SQL Server Concepts like SQL Architecture, Indexes, T-SQL skills & DMV.
- Database Maintenance/ Support tasks and lower level monitoring using tools like profiler, DMV, Perfmon
- SQL Server Replication, Backup/ Restore, maintenance plans and DR recovery strategies.
- Troubleshooting & diagnose issues with both SSIS & SSRS (Deploy, design, Security, Tuning, Creating and enforcing Standards & best practices, automate)
- Understanding of system tables, stored procedures, functions, triggers & SQL tuning
- PowerShell scripting to automate DBA related tasks. Ability to understand existing automated tasks and tweak/troubleshoot them.
- General troubleshooting like assisting clients with various issues related to connectivity, permissions, access, distributed queries issues, suggesting solutions, best practices etc.
- SQL Server Security, adept in creating and maintain complex User and permission management environment using AD groups, DB roles, SQL ids and Proxy accounts.
- Experience with ETL tools such as PowerCenter Informatica using Crystal and WEBI reporting.
- Knowledge of SQL Server database tuning using Profiler and other third-party tools.
- Hands-on experience with SQL Server installations and patching.
- Knowledge of clustering, Always on / multi node clusters at the time of DR process.
- AWS cloud experience (EC2, EMR, S3, Kinesis, Dynamo, API (Application Programming Interface) Gateway & LAMDA)
Job Category:
IT - Application Development
Posting End Date:
29/06/2024
Skills
Asset ManagementInvestmentTroubleshootingFinancial PlanningFinancial ServicesInsuranceMutual FundsAnalysisDrivingAnalystInvestmentsRetirement PlanningSqlDistributionReportingFinancialIndexesMaintenanceManagementSql ServerIf a job posting appears fraudulent, asks for payment, contains misleading information, or violates our guidelines, please report it immediately. Our team will review it promptly, Jobaaj does not charge any fee from the applicants.
About Company
Sun Life Financial Services offers dynamic career opportunities in the financial services industry. As a leading global provider of insurance, wealth, and asset management solutions, Sun Life empowers individuals to achieve financial security and well-being. Join Sun Life Financial Services Careers for a chance to make a meaningful impact and grow professionally in a supportive and inclusive environment. With a commitment to innovation and customer-centricity, Sun Life fosters a culture of collaboration and excellence. Explore rewarding career paths and unleash your potential with Sun Life Financial Services Careers. Join us in shaping a brighter financial future for individuals and communities worldwide.
Similar Jobs
View allLooking for something similar?
New Stock Market Trading Asset & Wealth Management roles in Bengaluru.
One email a day. Unsubscribe any time.

