Infra. Technology Specialist

Cognizant

2 - 5 years

Coimbatore

Posted: 29/11/2024

Job Description



Job Summary

primary MSSQL DBA

secondary MySQL/Oracle DBA


Responsibilities

1. Installation and configuration of MS SQL Server 2005 2008/2008 R2/2012 2014 2016 2019 2022

2. Migrating databases from SQL Server 2012/20014 to SQL Server 2016 2019 2022

3. Experience in MS SQL Server performance tuning along with SQL Profiler client/server connectivity query optimization Database Maintenance plans Database Consistency Checker using DBCC.

4. Experience in Production support on SQL Server Database Administrator and handling P1 and P2 tickets

5. Configuring and monitoring the Database Mirroring and Log Shipping replication clustering.

6. Working closely with IT to support physical database administration including performance management security installations upgrades

7. patches backup recovery space management performance tuning and capacity planning

8. Maintain backup and recovery process including disaster recovery performance and tuning of database and application

9. Managing database backup and recovery

10. Managing database security roles and profiles

11. Ensure data requirements have been identified design is fully normalized and database complies with industry best practices and strict security requirements

12. On-call support to maintain 7x24 coverage of the database environment Provides business with day-to-day stable and optimally designed tested and implemented database environment that

13. Minimize database downtime and manage parameters to provide fast query responses

14. Perform tests and evaluations regularly to ensure data security privacy and integrity

15. MCTS MCITP and/or MVP certifications a plus

16. Performing SQL DBA tasks in a team maintaining operations of enterprise data centers

17. Installing configuring and patching SQL Servers and Clusters

18. Troubleshooting and diagnosing database issues

19. Performance tuning

20. Database monitoring

21. Recommend and implement emerging database technologies.

22. Create and manage database reports visualizations and dashboards.

23. Create automation for repeating database tasks.

24. Strong command of SQL and SQL server tools

25. Monitor performance and setup alerts to avoid performance issues occurring on databases.

26. PowerShell and Unix shell scripting skills

27. Familiarity with SSAS SSIS SSRS


Certifications Required

Relevant certifications

About Company

Cognizant is a global leader in technology and consulting services, helping businesses transform their operations through digital solutions. Specializing in IT services, including software development, business process outsourcing, and consulting, Cognizant supports clients across industries such as healthcare, financial services, manufacturing, and retail. With a focus on innovation, Cognizant assists organizations in modernizing their technology, improving operational efficiency, and enhancing customer experiences. Headquartered in the U.S., it is consistently ranked among the most admired companies in the world and is a member of the NASDAQ-100.

Services you might be interested in

One-Shot Campaign

Reach out to ideal employees in one shot!

The intelligent campaign for reaching out to the ideal audience to whom you can ask for help (guidance or referral).