Services
Priority DM . 2 days reply
Video meeting . 30 mins
Video meeting . 30 mins
Video meeting . 60 mins
About me
Database Engineer with experience of more than 12 years using T-SQL language, reporting, tuning, database design, coding and testing different scenarios where you can get the best performance from your applications. My Passion is database tuning using different techniques whether is query refactor, indexes creation or improving the application architecture. During my experience, I have dealt with performance issues from the database perspective where I have used my creativity to refactor a query passing from minutes to just seconds., I called that magic for end users.
Skills and Responsibilities:
• Advanced knowledge in Stored Procedures, Triggers, Functions, Views, Indexing on SQL Server.
• Experienced in generating reports using SQL Server Reporting Services and Crystal Reports.
• Development of strategic planning, management, and execution.
• Background work in troubleshooting software development processes and implementing client requirements.
• Easiness to communicate with teams and clients.
Technical
• SQL server 2005,2008,2012,2014,2016,2019
• SQL Server Index and Query Tuning
• SQL Profiler, Database Tuning Advisor, DMVs, Execution Plans
• Database architecture, Design Patterns, Data Security and Administration
• BI Development (SSIS, SSRS, ETL)
• Windows Programming: Visual Studio Code
• TFS, Git, Jenkins, Active Directory, Windows Servers
• Scrum methodology
• Complex queries, Stored procedures, Data migration, SQLCmd
• Big Data: Hadoop, HDFS, Hive, Sqoop, Oozie, Impala, Spark, Pyspark, Spark SQL, Databricks, Airflow, Linux
• Familiar with SQL Server Cluster, Tableau, Crystal Report, PostgreSQL, Greenplum, MySQL, Oracle
• Database replication (CDC) MySQL and SQL server
• AWS Ecosystem: lambda, EC2, DMS, Kinesis, s3, SQS, SNS, RDS, Glue, Athena, Batch