Banner Image

Skills

  • Database Administration
  • Database Design
  • Database Development
  • Microsoft SQL Server
  • Query Optimization
  • SQL
  • Stored Procedures
  • Transact SQL

Services

  • SQL Development

    $20/hr Starting at $25 Ongoing

    Dedicated Resource

    Configure and manage SQL server databases and processes. Design, develop and implement database systems based on customer requirements. Monitor system's health and performance. Ensure high levels of performance,...

    Database AdministrationDatabase DesignDatabase DevelopmentMicrosoft SQL ServerQuery Optimization

About

I am a professional SQL developer/Administrator having more than 5 year experience.

I am a professional SQL developer/Administrator having more than 5 year experience.
Establish and Maintain Backups on Local and Remote Media.
Performance Monitoring and tuning Using Performance Monitor, DBCC Commands, Maintenance Plans, Third Party Tools.
Analyze Applications Performance Using Query-Execution Plans, Index Utilization and Procedure Cache Utilization.
In Database Programming, Use of Indexes, Normalization Techniques, Execution Plans, T-SQL And StorProcedures.
Database design development.
Tune Database Queries.
Optimization of SQL Server, Stored Procedures and SQL Scripts
Monitor Application Related Jobs and Data Replication Activities.
Monitor server performance using server management dashboard and activity monitor tool.
Monitor server spaces on daily basis and create spaces if required.
Import data in SQL server database from different format.
Create and manage a wide variety of different types of report and deliver them in a range of Formats.
Configure and manage SQL server databases and processes.
Design, develop and implement database systems based on customer requirements.
Monitor system's health and performance.
Ensure high levels of performance, availability, sustainability and security.
Analyze, solve, and correct issues in real time.
Provide suggestions for solutions.
Refine and automate regular processes, track issues, and document changes.
Develop stored procedures, functions, packages, triggers and views using T-SQL.
Maintaining ETL scripts and packages and writing test cases algorithm with the ability to perform automated testing to get a deeper understanding of the software.
Fraud detection in Health Insurance system SQL business logic development (Visio based algorithm structure to stored procedure conversion).
Review daily, weekly, and monthly database reports, including user reports and systems information, to spot problems and ensure that all databases and support systems are working at peak levels.
Evaluate existing da

Work Terms

Hourly worked on daily basis.

Attachments (Click to Preview)