Ms Sql Server Dba
Installing, configuring SQL Server & Migrating and Upgrading SQL Server databases.
- Database maintenance tasks (rebuilding and reorganizing indexes, updating statistics and running DBCC.)
- Scheduling Maintenance and other jobs, developing Database backup and Disaster recovery solutions.
- Setting up and monitoring high availability solution such as Replication, Mirroring, Log Shipping and Failover Clustering.
- Develop, Implement and Administer policies and procedures for ensuring the security and integrity of database.
- ETL and SQL Server Integration services (SSIS), creating reports in SSRS
- Proactive Monitoring of SQL Server using DMV'S, SQL Profiler, Activity monitor, Performance monitor and Event Viewer and Spotlight.
- Creating database objects (indexes, stored procedures, tables, triggers and constraints.)
- Defragmentation of indexes (reorganizing and rebuilding.)
- Participating in database development and production testing.
at this job
MS SQL Server Dba/developer, Data Modeler
- Development/Modifications of Store Procedures, Transactions, Creating DB schemas based on BRD, Troubleshooting and fix production problems (data and system related), prepare test plans for SQL projects, train and consult developers on functions and procedures creation (code review, promotion to QA and/or production), optimization, performance monitoring, index tuning. Convert MS Access applications to SQL/Oracle. Help with XML extracts. Set Full Text Catalog and maintenance. Use PL/SQL; t-SQL.
- Data analysis and cleansing, data transfer and operations, create reports and processes for reports, help with Crystal reports, CorVu, and create OLAP reports including data warehouse creation and maintenance, training with cube operations and pivot table use. Prepare data for application switch (SQL/Oracle), Transfer from Progress database to SQL. Help in QA processes. Crete data models per project requirements (Use ERWin). Work on Data repository/Data warehouse. Set and maintain linked servers, ODBC. Performing Data Transfer between Progress and SQL/Oracle
- DB Maintenance, installation (Cluster/no cluster), apply patches; create/monitor jobs, performance, space management, backup/restore, data connectivity, OLAP settings. Maintenance plans, jobs and DTS packages creating, manipulating. Use SpotLight to monitor and tune servers. 24/7 support
- Participate in research of ETL/BI tools.
at this job