Database Analystat BOLD (View all jobs)
Noida, Uttar Pradesh, India
BOLD is an established and fast-growing product company that transforms work lives. Since 2005, BOLD has delivered award-winning career services that have a meaningful and positive impact on job seekers and employers. BOLD’s robust product line includes a professional resume and cover letter writing services, scientifically validated career tests, and employer tools that help companies hire, onboard, and communicate with their staff.
In India, our infrastructure team uses mixture of IAAS & PAAS for migration and virtualization to create smooth website hosting which creates great consumer experience. All the products are on Microsoft Azure used for building, deploying, and managing applications and services through a global network of Microsoft-managed data centers.
This MS SQL Server DBA role requires a service oriented mentality with a high sense of ownership of the projects, problems and requests assigned. This role will be actively participating in a high energy development environment.
- Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
- Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
- Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
- Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
- Refine and automate regular processes, track issues, and document changes
- Assist developers with complex query tuning and schema refinement.
- Provide 24x7 supports for critical production systems.
- Perform scheduled maintenance and support release deployment activities after hours.
- MS SQL Server Administration experience required.
- Knowledge of SQL Server tools (Profiler, DTA, SSMS, PerfMon, DMVs, and system sprocs).
- SQL Development – ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints).
- Experience in troubleshooting and resolving database integrity, performance, blocking and deadlocking issues. Should also have knowledge on replication/HA, log, connectivity, security issues etc.
- Ability to identify and troubleshoot SQL Server Issues like CPU, memory, I/O, disk space and other resource contention.
- Experience in creating database architecture with associated schema as part of a software design process.
- Strong knowledge of index management, integrity checks, configuration and patching.
- Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
- Experience on backups, restores and recovery models.
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
- Experience on Windows server, including Active Directory.
- Excellent written and verbal communication.
- Flexible, team player, “get-it-done” personality.
- Ability to organize and plan work independently.
- Azure-Cloud, NoSQL: MongoDB/Graph Database, SSIS.
BOLD is a fast-paced, product company founded by two entrepreneurs passionate about helping people achieve their dreams. We stand together as a team empowering people to reach their professional aspirations. With our headquarters in Puerto Rico and offices in San Francisco and India, we’re a global organization on a path to change the career industry . Our vision is to revolutionize the online career world by creating transformational products that help people find jobs and companies hire the best candidates. A career at BOLD promises great challenges, opportunity, culture and the environment and you forge your own path ahead. Join us and discover what a great place BOLD is!
WHAT WE DO...
Since 2005, we’ve helped more than 10,000,000 folks from all over America (and beyond!) to reach higher and to do better. With multiple online destinations providing successful and effective products and services, we’re partners along the way- from building successful resume to interviewing with confidence and landing the offer.
WHAT MAKE US BOLD
We at BOLD share the same passion and commitment for what we do. We collaborate and strive to achieve the perfect balance between our work life and our personal life. Because for us at BOLD, working is not work. It’s a lifestyle, an experience and a culture. And this culture is infectious, original and driven by passion.
WHAT DEFINE US
- SOLVE REAL PROBLEMS: We are focused on solving significant problems that matter to us and our customers. We don't chase ideas and trends.
- CODE TODAY, DEPLOY TOMORROW: We make bold decisions, move fast and iterate quickly. We push ourselves and others to consistently deliver the best.
- BE WITH THE BEST: We surround ourselves with the best people, technology, tools to achieve something special together.
- STAY LEAN: We focus on doing less to achieve more. We embrace constraints and simplicity. We adapt quickly to the changing environment.
- EXPONENTIAL GROWTH: We never stop learning and career growth.
- TOOLS OF THE TRADE: We are working on the best in class technology and tools for your work.
PERK AND BENEFITS
- CAFÉ: Catered meals and an unlimited supply of snacks and beverages.
- ATTRACTIVE COMPENSATION: Highly competitive salary by industry standards.
- MEDICAL INSURANCE: Comprehensive medical insurance for you and your family.
- VACATION: 24 days of paid vacation and 10 national holidays.
- RELOCATION ASSITANCE: We'll fly you in, help you move & give accommodation for 2 weeks.
- FRIENDLY CULTURE: Open plan office, flat organizational structure, comfy office space and fun-loving people.
- TEAM OUTINGS: We have team outings, annual picnic and Annual party for you and your family.