{"id":"ea4c7d04-376c-428d-bc29-95d87658c058","company":{"id":"159c525b-ea4a-4f64-9d31-08ba0f6d4617","company_stack":[],"company_gallery":[],"company_stats":[],"company_about_section":null,"company_benefit_section":[],"company_testimonial_section":[],"company_culture_section":[],"onboarding_process":null,"ticker_logos":[],"gtn_companies":[],"role_category":[{"name":"TBC"}],"cta_color":"#333333","name":"ANSR Summit Consulting","short_name":"ANSR Summit Consulting","slug":"summit-consulting","description":"<p>ANSR is a market leader in enabling organizations to build, manage and scale global teams through Global Capability Centers (GCCs). We provide full life-cycle services including GCC design, set up and enabling operations. For over 18 years, companies cutting across size, industry and markets have relied on ANSR&rsquo;s expertise to successfully build global business and technology teams. Since its inception, ANSR has established over 90 GCCs. Our experience spans across industries including retail/CPG, banking, insurance, travel &amp; transportation, and healthcare. We operate in supply-rich locations like India, Central and Eastern Europe, South America, Canada, and Southeast Asia.</p>","short_description":"<p>ANSR is a market leader in enabling organizations to build, manage and scale global teams through Global Capability Centers (GCCs). We provide full life-cycle services including GCC design, set up and enabling operations.</p>","about_us":"We are a global leader in establishing and operating Global Capability Centers (GCCs) and have successfully led the establishment of some of the best managed GCCs in India. As a trusted partner, we help our clients leverage global talent, develop strategic business capabilities and in the process, build sustainable competitive advantage.","video_link":null,"logo_url":"https://talent500-public-prod-cb.s3.ap-south-1.amazonaws.com/company_logos/ANSR-logo-white-tagline_2347aff0326b496a8eb316e5e86cda69_cBR9Nzp_e8f623d73f4245ec8b9fe9e70814fa26.png","job_logo":"uploads/company_images/ANSR_jobs_logo.png","job_logo_url":"https://talent500-public-prod-cb.s3.ap-south-1.amazonaws.com/company_job_logos/ANSR_jobs_logo_0d8be0cab6b242aca96864350d9b70ae.png","show_powered_by_talent500_logo":false,"website":"https://ansr.com/","redirect_logo_url":"https://ansr.com/careers","linkedIn":"https://www.linkedin.com/company/ansr-consulting/","facebook":null,"twitter":"https://twitter.com/ansrglobal?lang=en","instagram":null,"hero_type":"2","nav_bar_color":null,"nav_items_color":"#FFFFFF","gallery_heading":"Gallery","company_image_url":"https://talent500-public-prod-cb.s3.ap-south-1.amazonaws.com/company_images/new_hero_Image_da1674fa163f42539088804475e907f6.png","meta_title":null,"meta_description":"","hero_h1":"We are ANSR. We help our customers build, manage and scale global teams.","hero_h2":"As we are well on our way to establishing 100 new GCCs in the next 3-4 years, we welcome you to experience growth like never before, work with, and learn from some of the best minds in the industry. Join us as we shape new business models that meet evolving customer needs.","primary_color":"#00242E","secondary_color":"#333333","cta_text":null,"jobs_subtitle":null,"mission":null,"stack_section_title":null,"stack_section_description":"","powered_by_logo_url":null,"cta_bg_color":null,"cta_text_color":"#00242E","cta_border_color":null,"h1_font_size":null,"h2_font_size":null,"h3_font_size":null,"h4_font_size":null,"body_size_1":null,"body_size_2":null,"h1_font_w":null,"h2_font_w":null,"h3_font_w":null,"h4_font_w":null,"body_w_1":null,"body_w_2":null,"public_name":null,"use_public_name":false,"unique_id":"531d70f1-903a-492e-913e-7591773822f1","head_favicon_url":"","head_title":null,"privacy_policy_name":"Privacy Policy","privacy_policy_url":null,"mandate_privacy_policy":null,"ticker_title":null,"publish":true,"company_font_family":"5","use_company_font_on_jobs_page":true,"gallery_section_name":null,"about_section_name":null,"testimonial_section_name":null,"benefits_section_name":null,"culture_section_name":null,"jobs_section_name":null,"is_job_displayable":true,"is_onboarding_skip":false,"company_specific_workflow":0,"third_party_company":false,"is_vendor_third_party_company":false,"priority_order":0,"order_of_about_role":1,"order_of_about_company":2,"whatsapp_company_logo":"uploads/company_images/Ansr.png","whatsapp_company_logo_url":"https://talent500-public-prod-cb.s3.ap-south-1.amazonaws.com/talent500-companies/whatsapp/logos/Ansr_ce9533b8cd6e4d96baf41011c3b401d9.png","whatsapp_job_bg_color":"#00242E","whatsapp_job_text_color":"#FFFFFF","engagement_type":1,"font_family":5},"location":"Gurgaon","primary_skills":["DBA or Database Administration","SQL","PostgreSQL or Postgre","AWS"],"secondary_skills":[],"experience_range":"8 - 12 years","job_qualifications":[""],"screening_questions":[{"id":"83f43711-e778-4b90-9571-048bb23bbe79","question_number":1,"description":"How many years of experience do you have in DBA / Database Administration ?","question_type":"MCSA","question_options":[{"option":"Less than 3 years","option_id":1},{"option":"3-5 years","option_id":2},{"option":"More than 5 years","option_id":3},{"option":"More than 6 years","option_id":4},{"option":"No experience, but have strong understanding and knowledge","option_id":5},{"option":"No experience, but I'm a quick learner","option_id":6}]},{"id":"7e96a6b8-178c-4b94-b643-815ccb79eb37","question_number":2,"description":"How many years of experience do you have in SQL version 2017 and above ?","question_type":"MCSA","question_options":[{"option":"Less than 1 year","option_id":1},{"option":"1-3 years","option_id":2},{"option":"More than 3 years","option_id":3},{"option":"More than 4 years","option_id":4},{"option":"No experience, but have strong understanding and knowledge","option_id":5},{"option":"No experience, but I'm a quick learner","option_id":6}]},{"id":"9b462e46-b288-4e7d-b8f0-12874d7d5168","question_number":3,"description":"How many years of experience do you have in PostgreSQL ?","question_type":"MCSA","question_options":[{"option":"Less than 1 year","option_id":1},{"option":"1-3 years","option_id":2},{"option":"More than 3 years","option_id":3},{"option":"More than 4 years","option_id":4},{"option":"No experience, but have strong understanding and knowledge","option_id":5},{"option":"No experience, but I'm a quick learner","option_id":6}]},{"id":"2931e8a8-f599-49f6-9e4c-678a65dd4109","question_number":4,"description":"How many years of experience do you have in AlwaysOn ?","question_type":"MCSA","question_options":[{"option":"Less than 1 year","option_id":1},{"option":"1-3 years","option_id":2},{"option":"More than 3 years","option_id":3},{"option":"More than 4 years","option_id":4},{"option":"No experience, but have strong understanding and knowledge","option_id":5},{"option":"No experience, but I'm a quick learner","option_id":6}]},{"id":"5c41ae4b-3771-4a53-a5cd-754d4b74dd0e","question_number":5,"description":"If selected, would you be willing to relocate to Gurgaon ?","question_type":"MCSA","question_options":[{"option":"Yes, willing to relocate","option_id":1},{"option":"No, not willing to relocate","option_id":2},{"option":"I am based in Gurgaon","option_id":3}]},{"id":"efb6a57a-8110-4e8b-99aa-692b8e7850d0","question_number":6,"description":"What is your overall years of experience ?","question_type":"MCSA","question_options":[{"option":"0-4 years","option_id":1},{"option":"4-8 years","option_id":2},{"option":"8-12 years","option_id":3},{"option":"12+ years","option_id":4}]}],"title":"Staff DBA","description":"<p><strong>Role and Responsibilities:&nbsp;</strong></p><ul><li>Monitor and troubleshoot database instances.&nbsp;</li><li>Perform root-cause analysis in response to database environment events.</li><li>Identify opportunities for improved system performance and process improvements.&nbsp;</li><li>Perform code reviews, and assist teams across the organization with query optimization.</li><li>Modify and build automated environment installation and setup processes.</li><li>Serve as a SME for specific technical topics and team operations.</li><li>Architect database high availability and database backup and restore processes.</li><li>Review and execute data manipulation scripts created by internal and external team members.</li><li>Build external networks to help accomplish team and company objectives.</li><li>Contribute to other team efforts as needed to support day-to-day database operations.</li><li>Complete infrastructure planning, provisioning, and maintenance tasks to ensure the required resources are available for application functionality</li><li>Complete functionality reviews for services and technology that both internal and external teams want to use in the database environment.</li><li>Create and drive project solutions that are consistent with stated objectives and guidelines.</li><li>Provide guidance to other DBAs on technology topics.</li><li>Recommend new technologies and processes that can be used to manage database environments.</li><li>Participate in production support on-call rotation to triage and resolve critical issues outside of business hours.</li></ul><p><strong>Job Requirement :</strong></p><ul><li>8+ years of experience as a Database Administrator working with SQL Server 2017 or higher.</li><li>3+ years of experience configuring and maintaining AlwaysOn Availability Groups.</li><li>Bachelor’s degree in Computer Science or another related field, or equivalent. experience in IT related fields.</li><li>Strong knowledge of cloud computing computing concepts and infrastructure management.</li><li>Expert knowledge of common database administration tasks such as backup &amp; restore, integrity checks, disaster recovery, and security.</li><li>Proven experience in performance tuning concepts.</li><li>Prior experience supporting database and application development teams.</li><li>Thorough knowledge reading and writing complex SQL scripts.</li><li>General knowledge reading and writing Powershell or other scripting technologies.</li><li>The ability to solve complex problems independently using analysis and research.</li><li>Strong communication (written and verbal) and collaboration skills, with the ability to provide technical input both internally and externally.</li><li>Strong critical thinking and analytical skills.</li><li>Experience working in a PCI/SOX, or other compliance regulated environment.</li><li>General knowledge of at least one other database technology.&nbsp;</li><li>Ability to work on-call rotation.</li></ul><h2><strong>Preferred:</strong></h2><ul><li>Master’s degree in technology, engineering or related field</li><li>General knowledge of PostgreSQL</li><li>AWS RDS\\Aurora PostgreSQL experience</li><li>IAC tools, (Terraform, AWS Cloudformation)</li></ul>","employment_type":"Full-Time","industry":"","job_template":true,"country":{"name":"India","country_code":"IN","region":"Asia"},"is_job_displayable":true,"job_url":"https://talent500.com/jobs/summit-consulting/staff-dba-gurgaon-T500-15730","created_at":"2025-01-07T15:29:36.342150+05:30","updated_at":"2026-04-14T05:45:43.103550+05:30","title_alias_1":"Staff DBA","slug":"staff-dba-gurgaon-T500-15730","summary":null,"typical_workday":null,"what_you_offer":null,"what_you_need_to_succeed":null,"responsibilities":null,"type":null,"min_experience_years":8,"max_experience_years":12,"ctc_unit":"LPA","is_featured_job":false,"is_active":true,"job_code":"T500-15730","external_id":23346,"external_job_code":"ALK014_CJ","is_anonymized":false,"mercurial_skills":null,"open_date":"2025-01-07T15:29:34.860407+05:30","published_at":"2025-01-07T15:29:34.853278+05:30","anonymization_needed":false,"anonymized_description":null,"xml_feed_anonymization":null,"unregistered_user_anonymization":null,"registered_user_anonymization":null,"pre_application_email_anonymization":null,"mettl_account":null,"job_table_sub_head":null,"job_table_short_desc":null,"is_remote":null,"job_video":null,"job_video_title":null,"job_video_description":null,"job_image_url":"https://wattt.s3.ap-south-1.amazonaws.com/PRODUCTION/T500-15730.png","role_summary":"<p><strong>About the role:</strong>&nbsp;</p><p>The Staff DBA will have a strong understanding of both business and team objectives, and use the information to formulate team processes and project solutions. The Staff DBA continues to carry out daily DBA operational tasks, while also providing guidance to other team members on tasks, and providing solutions to improve operational tasks. The Staff DBA displays the ability to learn and utilize basic functionality of new technologies. The Staff DBA will display the ability to plan, manage, and complete projects through completion.</p><p>&nbsp;</p>","syndication_control":true,"syndication_status":"in_progress","syndication_job_title_alias":"[]","sourcing_requirements_updated_at":"2025-01-07T15:29:36.052409+05:30","t500_sourcing_control":true,"status":"open","job_redirection_url":null,"is_external_job":false,"is_leadership_job":false,"leadership_confidentiality_level":null,"pricing_type":null,"recruiter":"1154daea-f24c-4f7f-aad6-494543ee6112","category":30,"job_sub_category":26,"role":null,"job_function":609,"job_sub_function":987,"naukri_industry":null,"naukri_functional_area":null,"naukri_role":null,"role_category":329,"linkedin_industry":null,"syndication_partners":["080e8887-744e-45fb-809a-22dc56405760","155c6cf4-8e99-4b9d-a962-30efd35c2aeb","32401301-1247-4c2d-be14-8c190cae33ab","56f3dcdd-b898-4806-ae12-c2578268f37c","5dc79af2-bfa4-4186-b589-219f71a4d5cf","75854529-b954-4c9e-9223-dd73e4bb564a","857f1932-f803-401a-a423-5f5350e015ed","9997eeaf-0206-4bb3-a458-e3823ad26e2f","a8812bb2-f253-4161-ad74-b2617497a612","a8bf9ce8-9d0e-401f-bb42-a409477787a6","aa8de7a4-71c0-4241-8523-33f47d7da6c6","da406e8f-edb1-4775-a465-4cfadb566bc8","dd8c2a4a-08ef-4849-8fd0-c5017b662841","fe38debc-5053-41c0-a94f-50ae47634eda"],"candidate_job_status":null,"candidate_job_id":null,"mettl_assessment_to_be_taken":false,"company_font_data":{"font-family":"Montserrat","url":"https://fonts.googleapis.com/css2?family=Montserrat:ital,wght@0,100;0,200;0,300;0,400;0,500;0,600;0,700;0,800;0,900;1,100;1,200;1,300;1,400;1,500;1,600;1,700;1,800;1,900&display=swap"}}