Home  Post Resume Quick IT Job Search  Advanced IT Job Search 
Skip Navigation LinksHome » Job Details
Lore Software Solutions
  Company Profile
Lore Software Solutions is located in Bangalore, India and provides simple and high quality software development and quality assurance solutions. It currently focuses on consultancy services and delivers these solutions for other software companies.
 
  Job Details 
Title: 

MS SQL Server Database Administrator - Bangalore

Posted On:  9/4/2019 2:24:54 AM
Designation: 

MS SQL Server Database Administrator

No. of vacancies:  2
Qualifications:  BE/ B.Tech (Engineering) (Computer Science )
Essential Skills: 
Not specified
Minimum Total Experience:  2
Job Tenure:  Full-time Only
Salary Offered:  DOE
Job Location:  Bangalore Karnataka India

  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 'best practices' 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 and Enterprise Editions)
• Windows/UNIX Environments
• Microsoft SQL Server Management Studio
• DTS/SSIS Tools
• Transact SQL
• SAN Storage Devices
• Shell Scripting
• Trading Applications

  Contact Information
Reference Name (If Any): 





 
Terms and Conditions | Privacy Policy | FAQ | Contact Us | Why?? | Link to us