Job Description

Are you looking for a supportive, collaborative workplace with great teams and inspiring leaders? You've come to the right place. We're looking for ambitious people who share our values and want to make every day better for people around the world. If this sounds like you, and the career below sounds exciting, we'd like to hear from you.

Working Arrangement Hybrid



We are looking for SQL Database Administrators to join our team!

Roles & Responsibilities:

• Lead complex troubleshooting or raised technical issues over a significant population of affected software or equipment.
• Handle backups, recovery procedures, DBCC utilities, index maintenance job & disk space.
• Recommend on stored procedure optimization, performance tuning & index tuning.
• Develop, maintain & report on database health checks.
• Resolve space management issues like TempDB contention, Data, and log file space issues.
• Identify and resolve blocking and deadlock issues.
• Manage database refresh jobs.
• Works closely with IT project managers, programmers, architects on currency initiatives.
• Planning, developing, testing and execution of Disaster recovery processes.
• Champion the culture of reliability mindset by embarking on opportunities to implement self-healing database solutions.
• Maintain security, compliance, database hardening, encryption standards, audit, and access control frameworks.
• Be responsible for implementation and maintenance of database setup, installation, configuration & monitoring.
• Consult, guide & mentor team members.
• Participate in on-call support rotation including after-hours/weekend duties as required.

Technical Requirements:

• SQL server 2019, 2017 & 2016 both on prem & Azure (IaaS & PaaS) cloud platforms.
• High Availability Solution-Clustering & Always On.
• Database backup/restore and disaster recovery.
• SQL server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance.
• 24 x7 dedicated support for SQL server production server.
• Database alerts and monitoring for both on prem and Azure cloud platform.
• Azure Active Directory & SQL authentication.
• Migration to Azure cloud including database upgrades from 2016 to 2019.
• Performance tuning and Query Optimization.
• Database hardening and security standards like TDE, SSL/TLS and auditing.
• Database health check, reports, and metrics.
• Database software (SQL Server) upgrades.

Expert Knowledge in:

• SQL server patching management.
• Standard Operating Systems (Unix/Linux/Windows) in a multi-domain environment.
• Database monitoring tools and technologies (Foglight & NewRelic).
• Automation of DBA tasks using Power Shell scripts.
• ITIL process.
• Database Design principles.

SQL Server Tools:

• SQL Server Management Studio, Visual Studio, Query Analyzer, Profiler.
• Performance Monitor, OSQL, DTS, Log Shipping, Server Network Utility, Database Tuning Wizard.
• Index Tuning Wizard, SSIS, SSAS, SSRS, Microsoft Clustering Services (MSCS).

Preferred:

• Databases: DB2 LUW/ZOS, Postgre SQL, My SQL, No SQL & Oracle
• Integration to AIOps tool, Moogsoft

Other Experience:

• BSC Information Systems / Computer Science, or equivalent.
• 7+ years' experience managing production SQL Server environments.
• Agile and DevOps principles, test-driven development, continuous integration, and other approaches to accelerate the delivery of new features.
• Skilled to collaborate and build relationships with Manulife business and risk partners.
• Having the ability to quickly adjust to newer technologies as required.
• Certified with multiple disciplines of expertise and actively participate in new trainings as required.
• Ability to adopt and change with Manulife's vision.
• Good organizational and problem-solving abilities that enable you to lead through creative abrasion.
• Good verbal and written communication; able to articulate technical vision, possibilities, and outcomes.
• Self guided and able to lead smaller groups where required.
• Good analytical skills, copes with complex situations through deliberate analysis and planning.

What can we offer you?

Values-first culture
We lead with our Values every day and bring them to life together.

Boundless opportunity
We create opportunities to learn and grow at every stage of your career.

Continuous innovation
We invite you to help redefine the future of financial services.

Delivering the promise of Diversity, Equity and Inclusion
We foster an inclusive workplace where everyone thrives.

Championing Corporate Citizenship
We build a business that benefits all stakeholders and has a positive social and environmental impact.

Every career at Manulife/John Hancock provides the opportunity to learn new skills and move your career forward. Ready to make an impact somewhere? What are you waiting for? Apply today.

About John Hancock and Manulife

John Hancock is a unit of Manulife Financial Corporation, a leading international financial services group that helps people make their decisions easier and lives better. We operate primarily as John Hancock in the United States, and Manulife globally, including Canada, Asia and Europe. We provide financial advice, insurance and wealth and asset management solutions for individuals, groups and institutions. Assets under management and administration by Manulife and its subsidiaries were CAD$1.3 trillion (US$1.1 trillion) as of June 30, 2021. Manulife Financial Corporation trades as MFC on the TSX, NYSE, and PSE, and under 945 on the SEHK. Manulife can be found at .

One of the largest life insurers in the United States, John Hancock supports more than 10 million Americans with a broad range of financial products, including , , , , and . Additional information about John Hancock may be found at .

Manulife is an Equal Opportunity Employer

At Manulife/John Hancock, we embrace our diversity. We strive to attract, develop and retain a workforce that is as diverse as the customers we serve and to foster an inclusive work environment that embraces the strength of cultures and individuals. We are committed to fair recruitment, retention, advancement and compensation, and we administer all of our practices and programs without discrimination on the basis of race, ancestry, place of origin, colour, ethnic origin, citizenship, religion or religious beliefs, creed, sex (including pregnancy and pregnancy-related conditions), sexual orientation, genetic characteristics, veteran status, gender identity, gender expression, age, marital status, family status, disability, or any other ground protected by applicable law.

It is our priority to remove barriers to provide equal access to employment. A Human Resources representative will work with applicants who request a reasonable accommodation during the application process. All information shared during the accommodation request process will be stored and used in a manner that is consistent with applicable laws and Manulife/John Hancock policies. To request a reasonable accommodation in the application process, contact .