SQL Development / Administration

SQL Development/Administration

Using the SQL coding language, I have created tables, writes queries, and ensures that these queries perform at optimal speeds. Most SQL developers are either database administrators or experts in managing database development. There are different flavors of SQL depending on the platform you use, but they all perform the same basic functions—retrieve, add, edit, and delete database data.

My Responsibilities

  • Help write and optimize in-application SQL statements
  • Ensure performance, security, and availability of databases
  • Prepare documentations and specifications
  • Handle common database procedures such as upgrade, backup, recovery, migration, etc.
  • Profile server resource usage, and optimize and tweak as necessary
  • Collaborate with other team members and stakeholders
  • Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems

My Skills and Qualifications

  • Strong proficiency with SQL and its variation among popular databases
  • Experience with some of the modern relational databases
  • Skilled at optimizing large complicated SQL statements
  • Knowledge of best practices when dealing with relational databases
  • Capable of configuring popular database engines and orchestrating clusters as necessary
  • Ability to plan resource requirements from high level specifications
  • Capable of troubleshooting common database issues
  • Familiar with tools that can aid with profiling server resource usage and optimizing it
  • Proficient understanding of code versioning tools such as Git
  • Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
  • Experience with backups, restores and recovery models