SQL DATABASE

1. SQL Server (troubleshooting, debugging, tuning and optimization of SQL queries and stored procedures) 2. Database administration (Replication, design experience with RDBMS. 3.DR: doing quality assurance of the database components released to production. 1. Will need to formulate a conseptual design for this team. Assist development staff with the debugging, tuning, and optimization of SQL queries and stored 2. Design and implementation of database replication strategies for both internal and DR requirements procedures. Determine, implement, and manage database backup and recovery strategies, with focus on PIT recovery 2. Ongoing database performance tuning and upgrades, including: monitoring and evaluation of all database patches and service packs. Assist setting up clustered SQL Server Environment 3. Quality assurance of the database components released to production. Ticket deployments. 4. Enforce DBA standards to all the stored procedure deployed to production. 5. Provide operational support to the reporting database servers. 6. QA the server and do daily, monthly health check of the server 7. Setup and manage the maintenance and backup plans, 8. Setup jobs, give permissions, perform monitoring and tuning 9. Design and manage database import / export processes used to populate test databases and global data marts. Assist setting up mirroring and log shipping 10. Deploy and support DTS and SSIS packages. Transact SQL and stored procedure development 11. Database modeling and design functions. Create and maintain database ERD diagrams. 12. Research problems and recommend corrective actions. Assit management with resource capacity planning 13. Assist OLAP and Data Warehouse environment when assigned. 14. Implement and enhance database security using proven methodologies. 15. Understand and maintain database replication health for all reporting environments. 16. Manage DR environment for the reporting servers. 19. Mentor DBAs of a small team and provide guidance to all the production issues facing the team. DESIRED PROFILE:- • BS degree (computer science or equivalent preferred) • Experience with MS SQL Server 2000, including use of Query Analyzer, stored procedures, DTS, Jobs and Profiler • Experience creating and maintaining an extraction, transformation, and loading process from source systems or files into a data warehouse • Ability to extract data from a data warehouse and package according to user needs • Familiarity with managing data in Microsoft Access and Excel • Understanding of XML helpful • Ability to plan, organize and work on multiple tasks simultaneously • Strong communication skills required • A desire to exceed project, client and co-worker expectations Experience – 0 to 3 yrs. Industry Type – Development and Designs Role – DATABASE ADMIN Functional area – Software/DBA Qualification Required- • SOFTWARE/B.TECH/DIPLOMA Location – Delhi Keywords –Basic Programming language/ Net Programming languages/Micro Visual Studio Age limit- 23-35 yrs. Interview Venue –Walking Interviews are going on.. Interview Time- 10:30 am – 6:00 p.m. Focus Corporate Alliance Pvt. Ltd. Contact person-Rashmi 4th Floor, Saraswati House,27, Nehru Place, New Delhi-110019,India Cont no- 8376029366/8376027656 Phone:011 2648 4800

(Please mention NCRJobs.in for reference)

(Please mention NCRJobs.in for reference)

Location :

Address :