SQL Server DBA duties and responsibilities
- Experience in both sql server DBA and DBA developer
• Configure and maintain database servers and processes
• Monitor system's health and performance
• Ensure high levels of performance, availability, sustainability and security
• Analyze, solve, and correct issues in real time
• Provide suggestions for solutions
• Refine and automate regular processes, track issues, and document changes
• Assist developers with query tuning and schema refinement
• Perform scheduled maintenance and support release deployment activities
• Database programming skills(writing and understanding Procedures , scripts..)
Good to have experience to SSIS,SSAS SSRS or any reporting tools.
Similar jobs
Roles and Responsibilities
Build database systems of high availability and quality depending on each end user’s specialised role
Design and implement database in accordance to end users information needs and views
Define users and enable data distribution to the right user, in appropriate format and in a timely manner
Use high-speed transaction recovery techniques and backup data
Minimise database downtime and manage parameters to provide fast query responses
Provide proactive and reactive data management support and training to users
Determine, enforce and document database policies, procedures and standards
Perform tests and evaluations regularly to ensure data security, privacy and integrity
Skills
Proven working experience as a Database Administrator
Hands-on experience with database standards and end user applications
Excellent knowledge of data backup, recovery, security, integrity and SQL
Familiarity with database design, documentation and coding
Previous experience with DBA case tools (frontend/backend) and third party tools
Problem solving skills and ability to think algorithmically
Degree in a computer discipline or relevant certification
- Experience 4 - 8 years
- Key Skills for Software Developer C++, Linux :
- - Looking only for candidates who can join immediately or max 10 day
- - should be able to work independently with no handholding
- - the ability to work with C/C++ code on Windows/Linux platforms
- - Database knowledge of MSSQL, Oracle, MySQL/MariaDB, ideally other ones too: Saphana, Teradata, Postgres.
- - Ability to work on their own fixing defects
- - should be able to understand secure coding practices
- - should have the Ability to work independently and with the team across different time zones
- Manage SQL Server databases
- Configure and maintain database servers and processes
- Monitor system's health and performance
- Ensure high levels of performance, availability, sustainability and security
- Analyze, solve, and correct issues in real time
- Provide suggestions for solutions
- Refine and automate regular processes, track issues, and document changes
- Assist developers with query tuning and schema refinement
- Provide 24x7 support for critical production systems
- Design, develop, implement and maintain our core Oracle applications.
- Maintain our SQL / PLSQL processes.
- Ensure DB availability.
- Proactively manage and maintain security standards and controls by creating storage database structures with high-level security features.
- Actively seek to optimise and simplify our architecture.
- Take ownership of performance and capacity monitoring aspects of the DB.
- Execution of data migration jobs and scripts as required.
- Assist the infrastructure team in sizing hardware used for the DB.
- Support and collaborate with product developers.
- Contribute to the creation and maintenance of disaster recovery plans.
- Work closely with the application vendors, co-ordinate and manage the DBA activities.
- Own and follow up with Vendors/Stakeholders & their DBAs when required.
- Create a reliable backup strategy. Ensure database backups are appropriately
- executed and periodic restorations are exercised to ensure backup quality.
- Determine and document DB policies, procedures and standards.
- Performance testing and evaluation to ensure data security, privacy and integrity.
- Identification of bottle necks and deadlock issues.
- Ensure SLA's & operational KPI’s are met, working as necessary with internal and external support functions when major incidents occur.
- Install upgrades and security patches.
- Alter storage structures to meet the evolving needs of the company.
- Set up database user accounts.
- Train users on how to access the information in the database.
- Find and debug malfunctioning programs affecting the database integrity.
- Create autonomous database backups.
- Regularly update the database security protocols.
Desired Skills:
- Ideally Oracle Certified DB Professional (OCP) with more than 5 years’ experience with Oracle, preferably in a lead role.
- Technical degree preferable (B.E. / B. Tech).
- Must experience with an organisation that has 24x7 reliability on its database.
- Must have experience with Oracle Exadata.
- Must Operating system experience in Linux.
- Must hands on knowledge of Shell scripting on Linux Platform
- Must hands on knowledge of Oracle management tools (Data Guard, RMAN).
- Must hands on knowledge of SQL / PLSQL.
- Experience should include DB design (modelling and normalisation), capacity planning, performance tuning, storage management, back-up and recovery, managing schemas, report generation and DB clustering technologies.
- Knowledge of Partitioning.
- Knowledge of architecture design principles.
- Good problem solver, focused and dedicated developer with ability to work on
- your own as well as with a team.
- Hands on experience with DB standards and end user applications-translating
- capacity requirements into infrastructure deployment technology.
- Strong practical experience of ORACLE in a production environment (Ver 19c).
- Must be a self-starter with a strong attention to detail.
- Experience working with community version PostgreSQL version 13 (or higher)
- Experience investigating/troubleshooting PostgreSQL performance issues with native Postgres catalog and statistics
- Familiarity with streaming and logical replication, HA, Backup and Recovery and Maintenance utilities including setup, configuration and monitoring.
- Strong troubleshooting and analytical skills
- 5+ years of PostgreSQL DBA experience
Job Title – Sr. Database Developer and DBA MS SQL Server
Job Location – Bangalore
Experience – 8 to 10 years
CTC – 10-12 LPA
Job Description
- 8-10 years of industry experience with an appropriate University technology degree (BE,BTech,MCA)
- Should have extensive Hands-on experience in managing RDBMS Production and application DBA for MS-SQL Database.
- Must be proficient in MS-SQL programming and can handle complex logic.
- Knowledge of data structure and algorithms is a plus.
- Must have good experience in SSIS and SSRS using MSSQL Sever 2016 or later
- Monitoring, maintaining, Query tuning, performance tuning, cluster management for all RDBMS Production and application (MS-SQL).
- Database server administration with focus on security, automation, tuning, optimization, and standardization of new and deployed systems.
- Be able to work as a DBA lead and individual contributor for RDBMS platform.
- Will be responsible for database server planning with regards to scalability, redundancy, and data preservation of backend systems.
- Will develop High Availability Clustered server/network RDBMS topologies.
- Write comprehensive documentation, help develop tools to monitor systems performance, and work on optimization and tuning of various systems.
- Working with Production support teams on troubleshooting Incidents on a 24x7 basis. Looking for Sr. Sql Server DBA Who Would Provide Technical Support In Analysis, Design, Testing, And Deployment Of All Database Platform.