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
Job Description: Network Fresher
Role: Network Fresher
Experience: Fresher (Will be working as a Trainee for 1 year)
Location: Bangalore
Notice Period: Immediate
Shift Timings and Working Days: Rotational Shifts & 6 Days working (complete work from office)
Current Location: Candidates must be currently located in Bangalore
Required Skills:
- Basic understanding of networking concepts and protocols.
- CCNA training is mandatory.
- Knowledge of Linux, server management, AWS, and cloud computing.
- Strong analytical and problem-solving skills.
- Ability to work in rotational shifts.
- Excellent verbal and written communication skills.
Educational Qualification:
- Graduation must (B.Tech / B.Sc / B.E / BCA). Candidates should have a provisional or passing certificate.
- 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
10+ years of experience in SQL Server Administration
Should be hands on
Able to handle customer communication and expectation management
Proactively plan and implement the project/support activities
Focus on continuous improvements
Must have experience in managing team of SQL Server DBAs
should have good customer and client management skills
should have good communication skills
- 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.
Database Management and complete DATA BASE ORIENTATION OF CLIENTS IN THE SOFTWARE SYSTEMS AND PUNCHING THE DATA INTO THE SOFTWARE ASSIGNED.
-Troubleshoot and resolve all problems encountered with hardware and software.
-Laptop, MAC pcs, Troubleshoot and resolve firewall, desktop, hardware, connection, printer, and software issues.
-Update network applications as required. Maintain daily tape backup and off-site tape storage
Administration of all networks, servers, and storage infrastructure to Build, test, implement, operate, patch, monitor, backup, update, and secure
-Hardware / Software configuration of Servers, Switches, Routers, Firewalls, and storage system
Maximize corporate network services uptime by maintaining the corporate network, server, and storage infrastructure
-Maintain and manage VPNs and routers and Troubleshoot Management of personal queries
Provide Mobile device support and Maintain all the devices and regular check of the personal devices of the Management and Employees.
Desired Candidate Profile:
-Outstanding organizational and time management skills, Analytical thinker, and problem solver. Attention to detail is Crucial.
-Experienced Symantec Antivirus/Cisco VPN solutions, Hands on experience in networking, routing and switching, and Administration
-In-depth knowledge of best practices around management, control, and monitoring of server infrastructure.
- 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.