Farhan — Database Specialist / DBA
Farhan
Pay Rates
Industries Served
Languages
Service Radius & Travel
Will Work
Eligibility
Work History on Automate America
Achievements
3
Tenure
Profile
Skills
Programming Skills (5)
Database Administration, Configuration & Support, Performance Tuning, Replication Setup Developed a customized utility in.NET using mysqldump to take logical backup, table-wise with concurrent threads
Designed, developed and implemented ETL process using SSIS that was copying data from different transactional systems to a datawarehouse (approx. 10 million records per day). Further designed a process in T-SQL to process data and displays on Online Reports. Another project was to designeETL flows for loading CCLF files having medical insurance claims and mapped to datawarehouse
Database Design, Development, Performance Tuning, T-SQL & SQL
Designed & Developed different data web application using ASP.NET/VB.NET
Developed a complete database monitoring tool for MySQL Replication/Events Monitoring Another project was to develop a multi-thread backup for MySQL databases
About Me
- Database professional with over 12 years of experience in providing OLTP & OLAP solutions end-to-end in Telecom, Call Center, Leasing, Healthcare and Ecommerce sectors
- Hands-on with Microsoft SQL Server and Open Source Technologies such as MySQL, PostgreSQL & their Eco-System
- Process expertise in converting problem statement into technical specifications, transactional database analysis, data design & modeling, presenting solution architecture in well-documented designs
- Designed and implemented data-warehouse (normalized to de-normalized schemas), data marts and multidimensional reporting
- Proficient in designing ETL processes using SSIS & Talend; having strong SQL writing skills
- Installation, Administration & Support of Production Database Servers, HA/DR Replication & Cluster setup, Database Migration & Upgrades
- Skilled at practicing project management processes to manage and successfully deliver assigned IT projects on time
- Having release delivery experience while following Agile-Scrum methodology
- Analytical thinker that consistently resolves ongoing issues or defects, often called upon to consult on problems that eluded resolution by others
- Excellent communication, problem-solving & client interfacing skills, self-driven and team player
- Well experienced in working at multi-cultural and/or geographical-distributed work environments using Citrix-GTM, Cisco-WebEx
Software Competencies (7)
Professional Competencies (3)
Database Performance Tuning, Troubleshooting, Database Crash Recovery
Telecom, Call Center, Data Clearing & Financial Settlement, Asset Financing and Leasing, Health Insurance, Ecommerce, ERP
ETL: MS SSIS, Oracle ODI, Talend Reporting: MS SSRS, MS SSAS, MS Proclarity Programming: C#, VB.NET, SQL, T-SQL
Applications (1)
Hands-on with Microsoft SQL Server and Open Source Technologies such as MySQL, PostgreSQL & their Eco-System Process expertise in converting problem statement into technical specifications, transactional database analysis, data design & modeling, presenting solution architecture in well-documented designs Designed and implemented data-warehouse (normalized to de-normalized schemas), data marts and multidimensional reporting Proficient in designing ETL processes using SSIS & Talend; having strong SQL writing skills
Why Choose Me
<p>One Database Professional</p> <ul> <li>a DBA (DBMS Configurations, Performance Tuning, Crash Recovery)</li> <li>a Data Modeler & Designer</li> <li>a ETL Engineer</li> <li>Microsoft/Oracle and Open Source (MySQL / PostgreSQL)</li> </ul>
Work Experience(3)
Being part of Database Services Team, Data architecture design, database setups with optimal configurations, forecasting & planning Ensure production database availability with best performance and security Oversee the team with technical leadership for efficient execution of tasks, monitoring & issue resolution of databases Provide on-call 24x7 support to ensure maximum uptime of production databases Review & ensure security controls, SOPs & business processes Research and identify new technologies/products, evaluate and recommend for seamless integration Plan & manage projects for implementation, migration and up-gradation of databases Develop backup and recovery strategy, and implement the same to protect company's data against the possible disasters. Resolve technical problems & issues relating to application databases (escalate to vendors if requires). Automation of different database administration related activities and alerts
Implement standardized solutions to manage database physical structures, functional capabilities, security, backups, replication, archiving/purging etc. Database performance tuning especially SQL query optimization Troubleshoot & resolve production database issues in accurate and timely manner within defined SLAs / OLAs & practice ITIL incident/problem management process Manage database physical & logical structures and its resources Maintain a good, healthy & friendly environment within & outside team Provide requested reports like RCA & Database Health Report
Re-designed & migrated datawarehouse, and during implementation coordinated with stakeholders to deliver a successful upgrade Collect, analyze & manage new service requirements by coordinating with clients and pass functional requirements to software development team Upon finalization of requirements, doing the impact analysis and accordingly manage the implementation of changes across different systems While being as senior database developer optimized the queries for online reporting system, implemented load balancer, designed and enforced backup and archiving policies Maintaining data quality, security, accuracy, reliability and integrity of all data Analyze data discrepancies reported from clients and provide technical guidance to concerned teams for corrective action Migration of existing website from ASP 3.0 to.NET technology using RDLC Migration of existing database from SQL Server 2000 to SQL Server 2005 Designed and implemented datawarehouse for the telecom clients Write SQL procedures and MDX queries for the reports Built multidimensional reports using SSAS cubes and Procalrity Designed, developed and implemented ETL process that was copying data from different transactional systems to the warehouse (approx. 10 million records per day)
Education / Training / Certificates(3)
Skilled at practicing project management processes to manage and successfully deliver assigned IT projects on time Having release delivery experience while following Agile-Scrum methodology
Facilities Worked At(2)
Frequently Asked Questions
- What does Farhan do?
- Farhan is a Database Specialist / DBA on Automate America, the global professional marketplace for skilled talent across industrial, commercial, and residential work.
- Where is Farhan located?
- Farhan is based in Washington Dc, Columbia.
- What does Farhan specialize in?
- Farhan works with Oracle, SQL Server Integration Services (SSIS), Microsoft SQL Server, ASP.NET using VB.NET and C# as a Database Specialist / DBA on Automate America, the global professional marketplace for skilled talent across industrial, commercial, and residential work.
- Is Farhan available for work?
- Availability unknown. Farhan has not marked it recently.
- How do I connect with or hire Farhan?
- Create a free profile on Automate America and send a connection or contract request from this profile. Farhan can then respond and coordinate the work directly through the platform.