SQL DBA(Junior 2 years of experience & Senior min 5 years ofexperience)Job Description Create and manage multiple databases including back-up, performancetuning, capacity planning, monitoring critical events and documentation Monitor, maintain database systems and troubleshoot problems that mayarise Maintain data integrity and security (manage roles and permissions ofdatabase users) Use tools like SQL Profiler for database tuning. Generate traces,execution plans, identify performance issues, deadlocks/contention andresolve them Develop strategies and implement solutions for managing back-ups,restoration and replication Create and manage constraints and indexes Support software developers with database operations including thedevelopment of complex SQL, tuning of DML and the creation of storedprocedures. Proactive archiving and shrinking of databases Define proactive alerts to take necessary actions.Requirement The candidate must be B.E or MCA with specialisation in either ComputerScience, IT, or Computer Technology etc. Sr. DBA is expected to have extensive experience writing storedprocedures and query tuning on high transaction systems Mirroring/replication of DB to different servers and differentgeographies is mandatory Managing and monitoring DB backups, and periodic restoration processes Managing and monitoring DB storage, Troubleshooting Data file issues Management of indexes locks, deadlocks etc Manage DB security Provide support during DR (disaster recovery) drills activities Knowledge in SQL Server Integration Services (SSIS), SQL ServerReporting Services (SSRS) and SQL Server Analysis Services (SSAS). Basic knowledge of ETL (Extract-Transform-Load) Sound knowledge of RDBMS concepts, database architecture and SQL. Proficient with SQL server profiler for monitoring and troubleshootingdatabase activity and performance Ability to develop procedure documents and maintain detailed databaserelated documents Innovative approach to work, constantly looking for upgrading thesystem to more efficient and effective new technologies.
Busisol Sourcing India Private Limited is looking for B.E/B.Tech,MCA.
Looking for B.E/B.Tech,MCA graduates profile.