Job | Dell Hiring:: Looking for SQL DBA in Bangalore : 6-9yrs

The sender of this email is registered with Naukri.com as Dell International Services

Experience required for the Job: 6 - 9 years Job Location: Bengaluru/Bangalore Apply Now   Reply Dear Candidate, Hi Hope you are doing well, This is Nandini from Dell Bangalore, This is regarding Job openings in Bangalore, please find the below mention JD and let me know. At least 7-9 years working as a DBA and desired experience of at least 1-2 years as a team lead or supervisor. 6-7 or more years of experience as a SQL Database Administrator/Engineer 6-7 or more years of hands on Production/Development DBA experience. Admin skillset * Database Administration for the SQL Server 2005 and above (Maintenance, Security, Upgrades, Performance Tuning, etc.) * Installing, Configuring and Upgrading SQL Server/Applying Service Packs * Server and Database Security Administration * SQL Server Replication Designing SQL Server Systems and Implement * A good knowledge of the physical database design * Create database objects (tables, indexes, etc.) * Write database procedures, functions and triggers * Tune database queries, tuning and Monitoring SQL Server * Code or data synchronization * Ensure data consistency in the database through DBCC commands. * Should Have experience with using Trace flags / Profiler to solve Dead Locks/Long running queries. * Should be very strong in replication concepts and troubleshooting replication issues with in SLA. * Disaster recovery/high availability * Failover Clustering * Data Modeling * Data Transformation and Loading * Experience with SSIS and SSRS troubleshooting * Upgrade from DTS to SSIS packages * Backup the current code for rollback purposes * Analysis - Analyze the data to determine the core problems * Testing - Test the various options to ensure they perform better and do not cause worse performance in other portions of the application * Plan growth and changes (capacity planning) * Perform general technical trouble shooting and give consultation to development teams * Interface with Microsoft Corporation for technical support. * Patch Management and Version Control Tools * Should have good understanding of the MS SQL, related utilities and tools * Identification - Use native tools like Profiler, Perfmon, system stored procedures, dynamic management views, custom stored procedures or third party tools * Backing Up and Restoring SQL Server, Knowledge of ALL MS DB backup and recovery scenarios * Establish and maintain sound backup and recovery policies and procedures * Backup tools * Performance tools * Check for failed processes * Research errors, Validate disk space is not low, validate none of the databases are offline or corrupt * Perform database maintenance : Perform both MS SQL and operating system performance tuning and monitoring Automation: * Monitor application related jobs and data replication activities (Automated) * Setup custom scripts to query for particular issues and email the team * Write error messages centrally in the application and review that data * Setup Operators and Alerts on SQL Server Agent Jobs for automated job notification SoftSkill * Should have sound communication skills with management, development teams, vendors and systems administrators * Setup and maintain documentation and standards * Review the current process to understand what is occurring * Determine what the business and technical problems are with the process * Document the requirements for the new process * Provide a strategic database direction for the organization * Should have the ability to handle multiple projects and deadlines * Should possess a sound understanding of the business Good understanding of the underlying operating system Regards, Nandini P.M Dell | HR Recruiter | Human Resources in.linkedin.com/pub/nandini-p-m/a/891/15b/ For career opportunities at Dell click on Careers @ Dell | To refer a friend click on Refer a Friend You are receiving this e-mail because your profile contained one or more of the following words that the recruiter searched on: " SQL DBA " Is this job relevant to you? Yes No

Your feedback would help us in sending you the most relevant job opportunities

Disclaimer: The sender of this email is registered with naukri.com as Dell International Services (Avadhesh_Sharma@Dell.com, Divyashree Greens,Survey # 12/1, 12/2A ,, Challaghata village, Varthur Hobli, Kormangla, Inner Ring Road,, BANGALORE, Karnataka - 560036) using Naukri.com services. The responsibility of checking the authenticity of offers/correspondence lies with you. If you consider the content of this email inappropriate or spam, you may: Report abuse by forwarding this email to: compliance@naukri.com You can also Block this Company from searching your resume in the database. Advisory: Please do not pay any money to anyone who promises to find you a job. This could be in the form of a registration fee, or document processing fee or visa charges or any other pretext. The money could be asked for upfront or it could be asked after trust has been built after some correspondence has been exchanged. Also please note that in case you get a job offer or a letter of intent without having been through an interview process it is probably a scam and you should contact compliance@naukri.com for advise. To be on the top of Employer's Resume Search Update Your Resume Now Create your own job alert to receive similar jobs posted on Naukri.com directly in your inbox. Your Resume has only 30 seconds to impress a Recruiter. Get your resume written by Experts. Call 1800-102-5557 now! (Toll-Free)