Sign In
 [New User? Sign Up]
Mobile Version

IT Analyst DBA

Chennai, TN
Job Code:
  • Engineering & Construction
Applying for this job will take you to an external site
  • Shortlist
  • Email Friend
  • Print

Job Details

Job DescriptionTo perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.o Installation Configuration and Administration of SQLo Experience in Disaster recovery, backup and recoveryo Experience in database migration/upgrades and patch managemento Expertise in Database Performance /Tuning, Query Optimizationo Experience supporting mission-critical system and ensuring 24x7 availability of production system.o Proven experience with troubleshooting principles, methodologies and issue resolution techniqueso Experience in writing power Shell scripts to automate, monitoring, perform maintenance operations.o Ability to work with 3rd party vendors to implement technology initiatives and resolve problems/issues/bugs.Experience in Foglight SQL Monitoring Tool configuration, alert configuration etc.Experience in HA configuration, setup and monitoring of Replication, Mirroring, AlwaysOn featuresMust be good in Analytical and problem solving skills Cloud computing o Demonstrated track record and experience with SQL Azure in managing and monitoring databaseo Experience working in PaaS,SaaS & IaaSo Demonstrated progressive experience in enterprise design and implementation.o Working as a team member with technical corporate engineering team.o Familiarity with ITIL concepts, specifically in the area of service delivery preferred.oRequires familiarity database objects, relationship and security. Requires clear written and verbal communication in a technical context. Experience in Legato Networker backup softwareSound knowledge on SQL ClusteringExperience in support of reporting services & integration services.Good to have SQL scripting knowledgeGood to have knowledge on Solarwinds monitoring toolIT Support industry 24X7 DB Support (BB Support on weekends)Support & Monitor MSSQL Staging and Production LandscapesSupporting Service Now and AR Tickets on DB IssuesSupporting SQL AzureConfiguring Foglight tool for SQL/ DB Server notification & AlertsRegular patch updates on MSSQL LandscapesAttending Conferences on SQL componentImplementing best practices on SQLProvision New DatabasePlanning / Sizing / Capacity Planning or Questions about proposed or approved projects//Architecture, (re)design or current/existing or new processes, systems, solutions including adoption of new processes from other groups such as computing, storage, backups, monitoring etc.Upgrades, Support packs, Kernels, Hardware replacements,Create Maintenance Plans, Scripts, Processes, Procedures, guides for standard operationsInstallation, Configurations, Tuning ParametersDesign, Deploy, build and ImplementAnalytical Trending for performance, capacity and availabilityMonitoring and responding to space, availability, errors, alerts, logs, standard jobsMaintain Monitoring systemsExtend SpaceMonitor Job Schedules in SQL ServerResearch and report on ORA errors before escalation to ENGInitial investigation into isolated performance issues - escalate quickly if it is a sev one major impactperform standard SQL Server DB recovery requestRespond to SQL Server User maintenance requests (following guidelines). (No Local Operating System Users - SQL User and Role assignments only)(No Oracle User maintenance)SQL Server - DB promotion to Prod or refresh to QA/DEV from Prod per requestsQualificationsRequires a bachelor's degree or an equivalent combination of education and experience. Requires at least 1 year related experience. Bachelors degree in Computer Science, Information Technology, related discipline or equivalent experience required;Minimum 3+ years of MSSQL database support. Requires knowledge of a wide range of programming languages. Must be expert at testing and debugging procedures. Must be able to evaluate user requirements relative to current application functionality. Requires clear written and verbal communication in a technical context.
Degree: ME/ M.Tech./ MS (Engg/ Sciences)

Additional Degree: BE/ B.Tech (Engineering)

Experience: 3-8


Configuration/Release Mgmt | Database Administration (DBA) | Quality Assurance/Testing | System Administration
Applying for this job will take you to an external site


© Copyright 2015 Al Nisr Publishing LLC - powered by Gulf News