MS SQL Server Database Administrator
- Xploretech Global
- 2 to 7 Yrs
- Bengaluru
- 5 years ago
- Email to a friend
- Report this job
Job Description
RESPONSIBILITIES:Build new database servers in support of both production and QA needs.
Upgrade servers to newest supported revs of Microsoft SQL Server 2008 including latest patches
Determine and test tuning parameter settings and trace flags required to provide optimal server performance.
Maintain a database housing all relevant information about production and QA servers; including their Solaris OS or Microsoft versions and settings and Microsoft SQL Server 2008 configuration information.
Coordinate with UNIX/ Windows System Administrators to insure new servers hardware specifications meet current requirements including CPU, SAN storage devices and solid state disk devices.
Interface with peers in Microsoft SQL Server user groups and symposiums to insure industry experience is available to ITG.
Respond to server or database software outage on a 24 x 7 rotation.
Assist application administration with production releases where database issues are involved, including but not limited to migration of data from old to new schemas.
Recover corrupted databases from backups and source data.
Evaluate software acquisition targets in development and QA environments.
Evaluate alternatives when multiple products are available.
Recommend and justify vendor product acquisition as appropriate
Assist Windows System Administrators with releases of software to target servers.
Review server performance statistics and report trends to application groups.
Perform real time monitoring of databases in distress.
Analyze server performance and recommend appropriate remediation when required.
Insure development production plans are in place for all significant server change projects
Review all development production plans for supportability and insure compliance with accepted best practices.
Create new database server plans and schemas to insure efficiency and supportability.
Develop lsquobest practicesrsquo standards for server development and management.
Maintain Sarbanes Oxley security practices and standards.
SKILLS AND EXPERIENCE:
Previous experience with Database Methodology, Database Management tools, current Database Standards, Data Modeling, Data Modeling tools and Meta Data Management
Proven knowledge of the relational database modeling and solid theoretical knowledge of relational database techniques
Proven knowledge of Transact SQL development methodologies, with data models
Proven knowledge of Microsoft SQL Server performance tuning for server and application support.
Proven knowledge of various Microsoft SQL Server support tools
Proven knowledge of database normalization techniques
Demonstrated ability to work independently, handle multiple tasks simultaneously and adapt quickly to changes
Demonstrated excellent communication (verbal and written) and interpersonal skills, and ability to gather and understand requirements in the financial sector
TECHNICAL KNOWLEDGE/ SKILLS:
Microsoft SQL Server 2008 (Standard & Enterprise Editions)
Windows/ UNIX Environments
Microsoft SQL Server Management Studio
DTS/ SSIS Tools
Transact SQL
SAN Storage Devices
Shell Scripting
Trading Applications
,
Employement Category:
Employement Type: Full timeIndustry: IT - Software
Role Category: General / Other Software
Functional Area: Not Applicable
Role/Responsibilies: MS SQL Server Database Administrator
Contact Details:
Company Name: LoreLocation(s): Bengaluru
+ View Contact
Fraud Alert to job seekers!
₹ Not Disclosed
Xploretech Global
IT/ITES Consultant, with a Payroll and recruiting domain,currently serving multiple clients in regards to manpower services.
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in
