Sia Tedy
Toronto,Canada
Summary
Results-oriented and highly skilled Senior SQL Server Developer with over 14 years of hands-on experience in designing, implementing, and optimizing complex database solutions. Proficient in crafting efficient T-SQL queries, stored procedures, and triggers to ensure optimal database performance. Adept at data modeling, database design, with a proven track record of successfully delivering high-quality database solutions. Demonstrated ability to collaborate with cross-functional teams to understand business requirements and translate them into scalable and robust database solutions. SQL Developer with 10 years of progressive experience in SQL Server, databases and application programming. Dedicated to building customized technical solutions in alignment with operational needs and objectives. Critical thinker, analyst and problem solver known for continuous delivery of quality products across diverse business environments.
Overview
15
15
years of professional experience
Work History
Senior SQL Server Developer
Iranian National Tax Administration
11.2011 - 11.2023
- Design and implement efficient and normalized database structures
- Writing and optimizing complex T-SQL queries, stored procedures, functions, and triggers
- Ensuring data integrity and consistency through appropriate use of constraints
- Analyzing and optimizing query performance using tools such as SQL Server Profiler and execution plans
- Implementing indexing strategies and other performance-enhancing techniques
- Managing database security, including user access, permissions, and role-based security
- Collaborating with application developers to ensure seamless integration with databases
- Optimizing database interactions for improved application performance
- Setting up monitoring solutions for database health and performance
- Collaborating with cross-functional teams, including developers, system administrators, and business analysts
- Documenting database design, processes, and troubleshooting procedures
- Ensuring databases comply with relevant data protection regulations.
- Enhanced database performance by optimizing SQL queries and stored procedures.
- Streamlined data management processes for faster retrieval of critical information.
- Collaborated with cross-functional teams to develop efficient database solutions in line with business requirements.
- Implemented proper indexing strategies, reducing query execution times and increasing system efficiency.
- Designed and maintained scalable, high-performance databases by following industry best practices.
- Reduced resource consumption through effective database partitioning and compression techniques.
- Ensured data consistency and integrity by implementing robust error handling and validation mechanisms.
- Assisted in the migration of legacy systems to modern SQL Server platforms, ensuring a smooth transition with minimal downtime.
- Conducted regular database maintenance activities to optimize performance and eliminate potential issues before they arose.
- Provided expert consultation on database design, optimization, and troubleshooting to internal stakeholders.
- Developed comprehensive documentation for all aspects of the SQL Server environment, enabling better understanding among team members and end-users alike.
- Trained junior developers on best practices in SQL Server development, fostering a culture of continuous improvement within the organization.
- Established strong relationships with key stakeholders by effectively communicating technical concepts in understandable terms.
- Diagnosed complex system issues using advanced debugging tools like SQL Profiler, resulting in more efficient problem resolution times.
- Delivered accurate, up-to-date data for business intelligence purposes by creating ETL processes using SSIS and T-SQL scripts.
- Designed and implemented TSQL queries for reporting and complex solution development.
- Implemented system enhancements to design and develop solutions to address problem reports.
- Documented analysis results and provided performance improvement feedback.
- Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
- Developed custom database objects, stored procedures and delivered application support.
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
- Analyzed business reports for prompt communication, follow-up and ongoing support.
- Followed standard practices for migrating changes to test and production environments.
- Created optimal technical solutions to user needs with in-depth system analysis.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Performed regular database backups to prevent information loss.
Senior Software Developer
Kian Soft Company
04.2009 - 11.2011
- Possess skills in both front-end and back-end development, allowing for end-to-end application development
- Implement features across the entire stack to create a fully functional application
- Collaborate with cross-functional teams, including other developers, designers, product managers, and stakeholders
- Participate in design discussions and provide input on technical feasibility
- Effectively communicate technical concepts to non-technical stakeholders
- Collaborate with designers and developers to bridge the gap between design and implementation
- Analyze and solve complex problems related to both design and development aspects
- Collaborated with cross-functional teams to integrate software components seamlessly into existing systems.
- Delivered high-quality code on time by effectively managing project timelines and prioritizing tasks accordingly.
- Designed reusable modules that expedited the development process for subsequent projects without sacrificing stability or performance.
- Met with stakeholders to provide detailed project reports and milestone updates.
- Discussed project progress with customers, collected feedback on different stages and directly addressed concerns.
- Documented technical workflows and knowledge to educate newly hired employees.
- Discussed issues with team members to provide resolution and apply best practices.
- Translated customer requirements into written use cases.
- Designed intuitive graphical user interfaces to improve user experience.
Software Support Technician
Omega Soft Co
09.2008 - 04.2009
- Provide front-line support to end-users, addressing inquiries, issues, and requests related to software applications
- Guide users through troubleshooting procedures and offer step-by-step instructions to resolve problems
- Analyze software-related issues to identify the root cause
- Collaborate with other support technicians, developers, or relevant teams to resolve complex technical issues
- Coordinate and assist with the deployment of software updates, patches, and upgrades
- Ensure that users are informed about new features and changes introduced in updates
- Provide remote assistance to users, either through phone support, email, or remote desktop tools.
- Improved software functionality by providing timely technical support to endusers.
- Collaborated with development teams to identify and fix software bugs, ensuring optimal performance.
- Conducted regular testing of new software releases, ensuring seamless integration and minimal disruptions for endusers.
- Provided exceptional customer service through clear communication, empathetic listening, and diligent problem-solving efforts.
- Delivered personalized training sessions on software features and functionalities for both novice and experienced users.
- Proactively identified recurring issues, suggesting improvements to the development team for future product updates.
- Created user accounts and assigned permissions.
- Monitored system performance to identify potential issues.
- Broke down and evaluated user problems, using test scripts, personal expertise, and probing questions.
Education
Bachelor of Software Engineering -
Azad University
Qazvin, Iran01.2007
Skills
- T-SQL Proficiency
- Performance Tuning
- Database Design and Modeling
- Automation and Scripting
- Monitoring
- Data Warehousing
- Net Programming
- Query Optimization
- Database Administration
- ETL Development
- Database Monitoring
- Data Modeling
- Data Migration
- Database Design
- Indexing Strategies
- Advanced T-SQL
- Agile Development Frameworks
- C# Programming
- Scrum Framework
Accomplishments
- Supervised team of 10 staff members.
Languages
English
Full Professional
Persian
Native or Bilingual
French
Professional Working
Personal Information
Title: SQL Server Developer
Timeline
Senior SQL Server Developer
Iranian National Tax Administration
11.2011 - 11.2023
Senior Software Developer
Kian Soft Company
04.2009 - 11.2011
Software Support Technician
Omega Soft Co
09.2008 - 04.2009
Bachelor of Software Engineering -
Azad University
Similar Profiles
Hadise NasriHadise Nasri
Accountant at Iranian National Tax AdministrationAccountant at Iranian National Tax Administration
Elizabeth BlazquezElizabeth Blazquez
Revenue Agent at National Tax Administration OfficeRevenue Agent at National Tax Administration Office
Mehdi FallahMehdi Fallah
Assistant Chief at National Iranian Oil CompanyAssistant Chief at National Iranian Oil Company