Job Search
We can help you build an exceptional career
SQL Server DBA IRC243788
Job: | IRC243788 |
Location: | India - Hyderabad |
Designation: | Associate Consultant |
Experience: | 5-10 years |
Function: | Engineering |
Skills: | indexing and perfomance tuning, SQL, SQL Server and SQL, SQL Stored Procedures, SQL Table Functions, SQL Triggers |
Work Model: | Hybrid |
Description:
SQL Server DBA with 8+ years of experience
Requirements:
Must have 13+ Years of exp
Should have 8 + years of experience as a SQL Server developer
Good knowledge of Designing and Development of database objects, i.e. Tables, Indexes, Keys, Stored Procedures,
Views, Functions, Triggers, and SSIS packages commensurate with the level of experience.
Excellent debugging skills to decode the logic of complex stored procedures.
Performance Optimization:
Identify and resolve performance bottlenecks in SQL queries (Stored Procs) and database operations.
Optimize database schema and queries for efficient data retrieval.
Query Tuning and Troubleshooting:
Analyze and optimize complex SQL queries.
Troubleshoot and resolve database-related issues and errors.
Performance Monitoring: Set up and maintain monitoring tools to proactively detect and address database performance
issues.
Excellent documentation skills should be able to read and translate the logic of complex stored procedures into simple language.
MS SQL Server DBA, Azure, Disaster Recover
Job Responsibilities:
Design, develop and implement database systems based on customer requirements.
Optimize database systems for performance efficiency.
Prepare design specifications and functional documentations for assigned database projects.
Perform space management and capacity planning for database systems.
Develop database tables and dictionaries.
Ensure data quality and integrity in databases.
Identify any issues related to database performance and provide corrective measures.
Create complex functions, scripts, stored procedures and triggers to support application development.
Participate in database design and architecture to support application development projects.
Perform data back-up and archival on regular basis.
Test databases and perform bug fixes.
Troubleshoot database related issues in a timely fashion.
Develop security procedures to protect databases from unauthorized usage.
Evaluate existing database and recommend improvements for performance efficiency.
Develop best practices for database design and development activities.
What We Offer
Exciting Projects: We focus on industries like High-Tech, communication, media, healthcare, retail and telecom. Our customer list is full of fantastic global brands and leaders who love what we build for them.
Collaborative Environment: You Can expand your skills by collaborating with a diverse team of highly talented people in an open, laidback environment — or even abroad in one of our global centers or client facilities!
Work-Life Balance: GlobalLogic prioritizes work-life balance, which is why we offer flexible work schedules, opportunities to work from home, and paid time off and holidays.
Professional Development: Our dedicated Learning & Development team regularly organizes Communication skills training(GL Vantage, Toast Master),Stress Management program, professional certifications, and technical and soft skill trainings.
Excellent Benefits: We provide our employees with competitive salaries, family medical insurance, Group Term Life Insurance, Group Personal Accident Insurance , NPS(National Pension Scheme ), Periodic health awareness program, extended maternity leave, annual performance bonuses, and referral bonuses.
Fun Perks: We want you to love where you work, which is why we host sports events, cultural activities, offer food on subsidies rates, Corporate parties. Our vibrant offices also include dedicated GL Zones, rooftop decks and GL Club where you can drink coffee or tea with your colleagues over a game of table and offer discounts for popular stores and restaurants!