SQL Server Database Administrator

Let's grow together






    Education

    B.E/B.Tech/MCA

    Experience

    4 to 6 Years

    Total Openings

    (closed)

    Key Skills

    Keyskills: SQL Server Database Administration, SQL Server 2008/2008R2, 2012, and 2016 support in Production, Development, and QA environments. SQL Server replication, Backup/Recovery, Disaster Recovery, and planning.

    Role and Responsibilities

    • Creation and scheduling of maintenance plans (database and log backups and clean-ups), DTS to SISS package conversions. Business intelligence package design.
    • Developed, deployed, and monitored SSIS packages.
    • Transferring the data (ETL) to Data warehouse (SQL Server) by SSIS.
    • Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
    • Setup database Maintenance Plans to reorganize indexes, re-indexing, and update the index statistics on the production databases.
    • Used system monitor to find the bottlenecks in CPU, Disk I/O, and memory devices and improved the database server performance.
    • Used SQL Server Profiler to monitor and record database activities of particular users and applications.
    • Performed day to day DBA activities such as monitoring SQL Server health, job status, addressing user requirements.
    • Experience in implementing SQL server security and Object permissions like maintaining database authentication modes, creation of users, configuring permissions, and assigning roles to users.
    • Knowledge in scheduling Backups/Restore and Maintenance plans using SSMS Tool.
    • Proficiency and expertise in SQL Server replication, Backup/Recovery, Disaster Recovery, and planning.
    • Experience in a complete ETL cycle including data analysis, database design, data mapping, and conversion, and data load.
    • Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduling SSIS Packages.
    • Experience in Extracting, Transforming, and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using DTS and SSIS services.
    • Data loading experience in SQL Server using SSIS ETL and experience in developing packages in SSIS and DTS according to the task.
    • Data analysis and Data migration by transferring them using SSIS packages.
    • 24/7 Production Database on Call Support.
    • Ability to work in a fast-paced environment, Good team player, and can work independently. Helped the database developers on technical issues.