Hong Kong trainee solicitor Jobs

New

Ms-sql dba expert - optimization & tuning

NorthBay is looking for a hands-on Microsoft SQL Server expert who can own the p...

Location

Pakistan , Lahore;Islamabad;Karachi

Salary:

Not provided

NorthBay

Expiration Date

Until further notice

Requirements

Overall 8+ years of experience with at least 5 years of Core SQL Server hands-on experience as a SQL Server DBA / Engineer, with a strong focus on performance and HA/DR in mission-critical environments
Deep understanding of SQL Server internals (storage engine, query optimizer, plan cache, buffer pool, TempDB behavior etc.)
Expert-level experience in diagnosing Wait stats, DMVs, Extended Events, Profiler/Tracing, Execution plan analysis, query rewrites, indexing strategy design
Troubleshooting CPU spikes, I/O bottlenecks, memory pressure, TempDB contention, log bottlenecks (e.g. WRITELOG waits) etc.
Expert in SQL & T‑SQL optimizations including SPs, Triggers, Views, Functions etc. along with in depth understanding of locking, blocking, deadlocks, and transaction-related performance issues
Ability to identify & analyze resource-heavy queries/processes and systematically optimize them (indexing, hints, plan guides, code refactoring, re-architecture where needed)
Hands-on expertise in designing, deploying, and troubleshooting Windows Failover Clustering (WSFC), Always On Availability Groups (AGs), Failover Cluster Instances (FCI), Log Shipping, Mirroring & Replication
Experience with AWS Cloud, EC2, Instance Families/Sizes, EBS Volumes, IOPS, Throughput, Networking, and Multi‑AZ Designs in relation to MSSQL Server Performance, HA/DR & Monitoring & Observability
Strong experience with database monitoring tools and enterprise level monitoring/observability expectations, including SQL Server dashboards (performance, waits, blocking, deadlocks, availability), Focus on Implementing actionable Alerting to reduce the noise
Experience with T-SQL, PowerShell & SQL Server Agent etc.

Job Responsibility

Optimize database architecture, configuration, indexing strategy, statistics, TempDB, log & data file layout in line with SQL Server best practices
Review MS SQL Server Configurations, Analyze and resolve performance bottlenecks across CPU, memory, I/O, and network
Conduct wait stats, DMVs, execution plans, and XEvents analysis to identify root causes
Review and refine MAXDOP, cost threshold for parallelism, memory settings, TempDB configuration, and disk layout to improve performance and stability
Review, tune, and refactor complex SQL and T‑SQL stored procedures, views, and functions
Identify and resolve locking, blocking, deadlocks, transactional contentions, and long-running queries by optimizing indexing and/or query tuning and rewrites
Assess and document existing HA/DR implementations across clusters, Troubleshoot and stabilize cluster switchovers/failovers, including issues seen during planned and unplanned events
Define and implement HA/DR designs to meet RPO/RTO targets & Develop/Test failover/runbooks
Improve the Proactive & Reactive Monitoring / Observability with recommending/implementing comprehensive monitoring & alerting across SQL Server health and performance, HADR/Cluster state, sync latency etc.
Recommend and implement best-fit monitoring tools (e.g. advanced Datadog usage, plus tools such as SQL Sentry, Redgate SQL Monitor, SolarWinds DPA, native SQL tools, etc.)

What we offer

Competitive salary and benefits
Fuel expense reimbursement
Paid holidays and vacations
Medical outpatient reimbursement & health insurance facility
Career path to make a difference in a highly productive environment

Fulltime

New

Home Care Aide

This rewarding, entry-level position provides consistent, flexible full-time/par...

Location

United States , Fayette

Salary:

Not provided

Arcadia Home Care and Staffing - an Addus family company

Expiration Date

Until further notice

Requirements

Able to pass a criminal background check
Must have a H.S. Diploma or G.E.D
Reliable transportation
Reliable, energetic, self-motivated and well-organized
Three references (2 professional, 1 personal)

Job Responsibility

Assist with personal care
Provide light housekeeping, laundry, meal preparation
Run Errands

What we offer

Offering DAILY PAY for select positions
Healthcare benefits
Employee benefits
Flexible schedule - full time and part time available
Direct deposit
Travel Reimbursement

New

Housekeeping Manager

As the Manager of the Housekeeping department at Glorieta Adventure Camps, you w...

Location

United States , Glorieta

Salary:

17.00 USD / Hour

Christian Career

Expiration Date

Until further notice

Requirements

Ability to communicate well with team members, staff, and guests
Ability to manage peers, full-time staff, and summer staff in a positive and respectful way when they are helping to clean under your supervision
Have proficiency in Microsoft Word, Excel, typing, basic math, basic computer functions, organization, and be detail-oriented
A strong desire to learn new things quickly
A strong sense of self-motivation
A personal relationship with Christ that permeates all aspects of his/her life
Previous experience in any of the duties listed is preferred
Good work ethic
Willingness to perform routine tasks regularly and on time, with deadlines weekly and monthly for most tasks
Have a natural ability or strong desire for organization

Job Responsibility

Uphold established standards of cleanliness in all guest spaces and manage staff to uphold the same standards
Hire and train full-time staff to grow the Housekeeping team
Take chief responsibility for the inventory, ordering, and management of all cleaning supplies and linens for guest rooms and meeting rooms
Keep the SDS for housekeeping all chemicals updated
Keep cleaning and servicing checklists updated and make cleaning assignments
Coordinate maintenance repairs and pest control for inside the buildings
Schedule team shifts, team 1:1s, summer staff training, deep cleaning
Take chief responsibility for the laundry room and coordinate linen pickup/drop off
Coordinate the creation and update of the Housekeeping App
Keep up with logistics and make requests based on needs

What we offer

On-site housing with utilities and appliances included
Medical coverage through CHM, employer-funded HRA, and pharmacy benefit plan - 100% paid by employer for employee and spouse
PTO - base amount of 20 days annually, sick leave, and volunteer time off
Retirement - After 1 year of employment, employer contributes 4% NEC and up to 4% matched
Camp program and retail discounts, including a free session of camp annually, friends and family lodging options and use of camp facilities for personal gatherings
On-site meals for employee and family during the summer and special occasions

Fulltime

New

Prenatal Account Executive

The Prenatal Account Executive is an outstanding prenatal sales executive with e...

Location

United States

Salary:

184569.00 - 248269.00 USD / Year

BillionToOne

Expiration Date

Until further notice

Requirements

Minimum three (3) years of outside field sales experience within the healthcare sector, directly calling upon providers in specified geographic territory
Demonstrated successful sales track record, understanding of buyer/decision maker types, exhibit effective selling, listening, presentation skills, and ability to assess and respond to customer needs (National awards a plus)
Excellent organizational and communication skills (written and verbal) with demonstrated ability to effectively present to both internal and external customers
Effective time management skills required with a demonstrated ability to assess and prioritize opportunity required
Exceptionally bright, flexible, self-motivated and results oriented with strong interpersonal and analytical skills and the ability to think strategically as well as execute tactically
Must act with a sense of urgency, with a focus on closing business
Ability to assess the needs of medical professionals and staff members with a focus on consultative sales, coordination of logistics, and problem solving
Strong desire to work in a startup environment and must work independently with an internal drive to be successful
Working knowledge and application of HIPAA laws, privacy, and ethics surrounding patient privacy and information
Demonstrated values and ethics that support BillionToOne's mission, goals, and professional code of conduct

Job Responsibility

Increasing utilization of UNITY Fetal Risk Screen and driving market development through direct sales to individual OBGYNs, MFMs, and Genetic Counselors
Identifying, developing, and managing commercial relationships with key opinion leaders in medicine and other key healthcare professionals
Effectively prospecting and cultivating new business and maintaining key relationships
Identifying and capitalizing on commercial opportunities for growth within a specific region or geography – predominately in OBGYN, MFM, and GC clinics, as well as hospital systems and Federally Qualified Health Centers
Creating and implementing a strategic business plan to grow utilization quickly in your geography
Managing the full lifecycle of the product sales process, including new business development and lead generation
Attending local tradeshows, industry conferences and networking events

What we offer

Working alongside brilliant, kind, passionate and dedicated colleagues, in an empowering environment, toward a global vision, striving for a future in which transformative molecular diagnostics can help millions of patients
Open, transparent culture that includes weekly Town Hall meetings
The ability to indirectly or directly change the lives of hundreds of thousands patients
Multiple medical benefit options
employee premiums paid 100% of select plans, dependents covered up to 80%
Extremely generous Family Bonding Leave for new parents (16 weeks, paid at 100%)
Supplemental fertility benefits coverage
Retirement savings program including a 4% Company match
Increase paid time off with increased tenure
Latest and greatest hardware (laptop, lab equipment, facilities)

Fulltime

New

AWS Data Architect

Location

United Arab Emirates , Dubai

Salary:

Not provided

NorthBay

Expiration Date

Until further notice

Requirements

Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related discipline
8+ years in Data Architecture, Data Engineering, or Cloud Architecture roles
Proven experience designing and deploying AWS Data Lake / Lakehouse architectures
Strong experience in enterprise-scale data integration and large data processing systems
Experience supporting FP&A, analytics, BI, or enterprise reporting environments is a plus
Hands-on expertise with AWS services: S3, Glue, Redshift, Lambda, Athena, EMR, Kinesis, Lake Formation, and related tools
Strong programming skills in Python and SQL
Deep knowledge of data modeling, schema design, warehousing concepts, and metadata management
Experience with BI tools such as Tableau, Power BI, or QuickSight
Strong communication and stakeholder management skills

Job Responsibility

Design and implement scalable AWS Data Lake and modern data architecture solutions for large-scale data management and analytics
Build and maintain robust ETL/ELT pipelines using AWS-native tools and modern data engineering frameworks
Ensure data accuracy, consistency, and reliability across ingestion and transformation flows
Develop data integration solutions to support FP&A, financial reporting, forecasting, and enterprise decision-making processes
Optimize AWS environments for performance, scalability, cost-efficiency, and automation
Implement and enforce best practices for data governance, data cataloging, lineage, security, IAM, and compliance across the Data Lake
Work closely with business analysts, data engineers, and analytics teams to deliver end-to-end data solutions aligned with business needs
Participate in critical workshops, events, and team engagements as required within the UAE and across the region

What we offer

Opportunity to work on high-impact AWS data architecture initiatives
Attractive salary and benefits
On-site role in the UAE with exposure to international teams and strategic projects
Career growth in a technology-driven, highly collaborative environment

Fulltime

New

Maintenance Technician

To fulfill our mission by being part of a team to prevent the facilities of Glor...

Location

United States , Glorieta

Salary:

15.00 USD / Hour

Christian Career

Expiration Date

Until further notice

Requirements

A personal relationship with Christ that permeates all aspects of his/her life
Ability to communicate well with team members, staff, and guests
A strong desire to learn new things quickly
A strong sense of self-motivation
Previous experience in any of the duties listed is preferred
Good work ethic is a must
Willingness to perform routine tasks regularly and on time, with deadlines weekly and monthly for most tasks
Have a natural ability or strong desire for organization
Willingness to perform many tasks alone and to be a problem solver
Excellent customer service skills

Job Responsibility

Perform tasks in various tradecrafts such as mechanical diagnosis, plumbing repair, minor electrical, HVAC diagnosis and repair, and others
Aid in electrical and plumbing repair under supervision of licensed journeymen
Help guests and residents with problems, such as hot water, toilet, shower, AC issues, electrical, plumbing, etc
Be on-call each week to help with on-site problems with guests
Perform preventative maintenance as well as repairs on existing problems
Stay on a maintenance schedule perform regular inspections on facilities and equipment
Maintain detailed records of work performed
Maintain clean and organized workshop and storage areas

What we offer

On-site housing with utilities and appliances included
Medical coverage through CHM, employer-funded HRA, and pharmacy benefit plan - 100% paid by employer for employee and spouse
PTO - base amount of 20 days annually, sick leave, and volunteer time off
Retirement - After 1 year of employment, employer contributes 4% NEC and up to 4% matched
Camp program and retail discounts, including a free session of camp annually, friends and family lodging options and use of camp facilities for personal gatherings
On-site meals for employee and family during the summer and special occasions

Fulltime

New

Regional Manager - Prenatal, LA North

We are looking for a Regional Manager - Prenatal, LA North with 4+ years of dire...

Location

United States , Los Angeles

Salary:

187272.00 USD / Year

BillionToOne

Expiration Date

Until further notice

Requirements

Minimum 4+ years of field sales management experience leading a team of sales reps at a molecular diagnostics/genetics company required, specifically out of Women’s Health, Prenatal, and/or Reproductive Health selling directly to OBGYNs, MFMs, GCs throughout the region, with an existing portfolio of convertible client relationships
Strong experience hiring, developing, coaching, and motivating a team of sales reps to exceed ambitious sales goals
Demonstrated successful sales track record (eg. multiple award winning - President’s Club, Chairman’s Club, Circle of Excellence or equivalent), solid negotiation and closing skills, strong data analysis skills, understanding of buyer/decision maker types, exhibit effective selling, listening, presentation skills, strong focus on pull through, and good follow through skills
Excellent organizational and communication skills (written and verbal) with demonstrated ability to effectively present to both internal and external customers
Effective time management skills required with a demonstrated ability to assess and prioritize opportunities required
Exceptionally bright, flexible, self-motivated and results oriented with strong interpersonal and analytical skills and the ability to think strategically as well as execute tactically
Must act with a sense of urgency, with a focus on closing business
Ability to assess the needs of OBGYNs & MFMs and their office staff with a focus on consultative sales, coordination of logistics, and problem solving
Strong desire to work in a startup environment and build out a new territory and team

Job Responsibility

Develop a comprehensive, data-driven sales strategy and business plan to build and grow market development throughout the LA North region
Build and lead a team of talented, high performing sales reps in the execution of sales strategies and optimization of opportunities to increase profitability and market share
Recruit, Hire, Train, Manage, and Develop representatives
Develop and enhance customized pitches to individual OBGYNs, MFMs, and prenatal Genetic Counselors
Use data to analyze sales results, identify industry trends, and stay abreast of competition to increase sales volume and drive success within territory

What we offer

Working alongside brilliant, kind, passionate and dedicated colleagues, in an empowering environment, toward a global vision, striving for a future in which transformative molecular diagnostics can help millions of patients
Open, transparent culture that includes weekly Town Hall meetings
The ability to indirectly or directly change the lives of hundreds of thousand patients
Multiple medical benefit options
employee premiums paid 100% of select plans, dependents covered up to 80%
Extremely generous Family Bonding Leave for new parents (16 weeks, paid at 100%)
Supplemental fertility benefits coverage
Retirement savings program including a 4% Company match
Increase paid time off with increased tenure
Latest and greatest hardware (laptop, lab equipment, facilities)

Fulltime

New

Database Engineer / DBA

NorthBay is seeking talented and motivated Database Engineers who are passionate...

Location

Pakistan , Lahore; Islamabad; Karachi

Salary:

250000.00 - 350000.00 PKR / Month

NorthBay

Expiration Date

Until further notice

Requirements

Up to 3 years of relevant experience in database deployment, management, and migration
Hands-on experience with PostgreSQL, MongoDB/DocumentDB, and AWS DMS preferred
Knowledge of Backup/Recovery, Clustering, Sharding, Replication, and CDC concepts
Familiarity with NoSQL databases (especially DocumentDB) is a plus
Understanding of data pipelines, ETL/ELT processes, and data engineering principles is an advantage
Experience in database monitoring, troubleshooting, performance diagnostics, and optimization
Strong understanding of OLTP and OLAP workloads
Excellent problem-solving and technical communication skills

Job Responsibility

Collaborate with technical leads to plan and execute database migrations successfully
Evaluate, design, and implement effective migration strategies ensuring data integrity and reliability
Understand database structures, schemas, dependencies, and security configurations (RBAC, Backup/Recovery)
Develop and execute validation plans to ensure post-migration performance and accuracy
Work closely with application and infrastructure teams to ensure business functionality and SLAs are achieved
Provide recommendations for performance tuning and optimization of databases

What we offer

Competitive salary and performance-based benefits
Fuel expense reimbursement
Paid holidays and vacation
Medical outpatient reimbursement and health insurance coverage
A collaborative, high-performance work environment with opportunities to make a meaningful impact

Fulltime

Hong Kong trainee solicitor

K&L Gates

Location:
Hong Kong

Category:
Legal

Contract Type:
Not provided

Salary:

Job Description:

Job Responsibility:

Requirements:

Additional Information:

Job Posted:
December 25, 2025

Looking for more opportunities? Search for other job offers that match your skills and interests.

Similar Jobs for Hong Kong trainee solicitor

Ms-sql dba expert - optimization & tuning

Home Care Aide

Housekeeping Manager

Prenatal Account Executive

AWS Data Architect

Maintenance Technician

Regional Manager - Prenatal, LA North

Database Engineer / DBA

Hong Kong trainee solicitor

K&L Gates

Location:Hong Kong

Category:Legal

Contract Type:Not provided

Salary:

Job Description:

Job Responsibility:

Requirements:

Additional Information:

Job Posted:December 25, 2025

Looking for more opportunities? Search for other job offers that match your skills and interests.

Similar Jobs for Hong Kong trainee solicitor

Ms-sql dba expert - optimization & tuning

Home Care Aide

Housekeeping Manager

Prenatal Account Executive

AWS Data Architect

Maintenance Technician

Regional Manager - Prenatal, LA North

Database Engineer / DBA

Location:
Hong Kong

Category:
Legal

Contract Type:
Not provided

Job Posted:
December 25, 2025