TECHNICAL SKILLS

• Install, configure, upgrade, maintain and migrate SQL server databases
• Build window serves and configure virtual storage disks
• Extensive experience in using all types of SQL server constraints, SQL server database design, databases maintenance, developing T - SQL queries, stored procedures, views, indexes and SQL Dynamic View(DMV) using SQL Servers
• Design, implement, and manage complex database cluster environments including SQL AlwaysOn Availability Group(AG), HA, and Disaster Recover Solution(DRS)
• Create and deploy Drill Down, Drill Through SSRS report, Ad-hoc Report, dashboard and Cascaded Parameterized reports
• Design, implement, and manage ETL, SSIS and SSAS
• Provide SQL server databases backup and restore strategy
• Proficiency with Window server and SQL server database
• Debugging, monitoring, troubleshooting, and conducting performance tuning for BI solutions and SQL server environment
• Create and develop detailed design, relational database data modeling and requirements documents for SQL Server environment
• Configuring and administering windows server 2016/2012
• Basic understanding skills of Python, Oracle, Power script, and NETBEAN,
• Implement and support software upgrade and patch management procedures design
• Implement data warehouse concepts such as star schemas, snow flake schemas, operational data stores and data warehouses
• Experience with WebSphere DataPower SOA Appliances
• Configuring WSP, MPGW Services in DataPower. Implemented WS Security, SSL
• Strong customer service orientation and problem solving skills
• Basic skills of SAN, RAID, LAN, DSN, DHCP, WAN, and IP concepts
• Implementing of System Development Life Cycle, Agile life-cycle project
• Proficiency with Microsoft Access Database and excel
• Setup and manage user accounts through Active Directory
• Implement DISA Security Technical Implementation Guides (STIG) on Window servers and SQL Server environment
• Perform and maintain SQL server databases storage disk.
• Proficiency with Visio, Veeambackup, Solarwind, VMWare, VCenter and Team Foundation Server (TFS)
• Good communication and interpersonal skills
• Ability to work independently as well as part of a team and handle multiple projects simultaneously

PROFESSIONAL EXPERIENCE

Confidential, Arlington, VA

SQL Database Engineer

Responsibilities:

• Install, configure, upgrade, and maintain SQL Server 2012,2014, 2016
• Implement and maintain smooth operation and physical design of databases. Conduct performance tuning of indexes and databases in general,
• Provide backup recovery and makes recommendations regarding enhancements and/or improvements for all critical SQL Server instances
• Assist in Configuring and administering windows server 2016/2012.
• Configure and manage HA, DRS Window clusters and SQL AlwaysOn, Availability Group(AG), replication, and mirroring
• Perform necessary security patches every month to our production and pre-production environments
• Assist SSL certificates to established the secure remote desktop connections
• Perform and maintain SQL server databases storage disk.
• Setup and manage user accounts through Active Directory
• Perform SQL server configurations in compliance with established DISA Security Technical Implementation(STIG)
• Maintain and perform technical support, database availability groups, daily databases maintenance task, security patches, and performance tune-up to all SQL server databases
• Performance DISA Security Technical Implementation Guides (STIG) on components for Windows, SQL server
• Ability to work independently as well as part of a team

Confidential

SQL Developer

Responsibilities:

• Performed migrating data from unstructured database (IBM Lotus Notes ) to structured database (SQL server database)Performed SQL server database performance-tuning expertise for SQL Server databases.
• Created SSIS(ETL) packages for moving data between databases
• Involved in creating complex stored procedures, SQL script, and function according to business requirement
• Created Drill Down, Drill Through and Cascaded Parameterized reports according to the customer requirement using SSRS from OLAP and OLTP data sources and deployed on report server
• Extensive experience in using all types of SQL Server Constraints, SQL Server Database design, databases maintenance, developing Transact- SQL queries, stored procedures, and indexes using SQL Servers
• Implemented and supported database software upgrade and patch management procedures
• Managed MS SQL Server database environments that support transactional data as the backend for numerous applications
• Designed, developed and maintained appropriately-scaled, effective solutions, including functions and stored procedures, to support data cleansing, migration and reconciliation activity in Microsoft SQL Server T-SQL
• Demonstrate a strong background in data modelling, data management and data manipulation
• Provided administration of database systems including installation, upgrades, configuration, monitoring, tuning, and maintenance

Confidential

Data Warehouse Developer

Responsibilities:

• Created and deployed SSRS report, Ad-hoc Report, and dashboard
• Designed and implemented ETL processes and data architecture
• Designed, developed, maintained and published logical/physical data models, entity relationship diagrams
• Created complex query, Views, Triggers, Indexes, Stored Procedures, User Defined Functions
• Developed and tested high performing extract, transform, cleanse, and load processes in real time
• Performed the design and extension of data marts, meta data, and data models.
• Collaborate with Data Modelers, Business Analysts and Application Analysts to identify and understand source system data, business requirements, and the data warehouse data model.
• Implemented map source system data to the data warehouse models.
• Define and capture metadata and rules associated with ETL processes.
• Conceived analytics and business intelligence platform architecture for clients, including internal and third-party clients
• Adapted ETL processes to accommodate changes in source systems and new business requirements.
• Monitored performance of ETL processes and develops improvement goals as needed.
• Consolidate and optimize available data warehouse infrastructure.
• Supported the analysis of requirements, design specifications, development, and technical and user documentation of report development through direct interaction with internal customers

Confidential

Information Systems Analyst

Responsibilities:

• Created, build, and maintained database objects (Forms, Queries, Reporting, Macros, and Modules).
• Developed several access databases from excel spreadsheet.
• Examined the performance of the system and make adjustments as required and modify it and look for faulty in the programs.
• Provided Budget formulation and execution.
• Assisted in configuration, installation, and troubleshooting of application.
• Created, maintained, evaluated and updated database integrity and security settings.
• Created documentation on how these databases worked.
• Prepared training and technical manual for users.
• Assisted users in implementing new system modules and updating existing modules.
• Collected user’s requirement and incorporate them into database.
• Created and modified SQL server database according to the requirement.
• Created SQL jobs and also maintain the jobs as daily basis as well as weekly basis..
• Created snapshot replication and transactional replication in the SQL Server 2012.
• Maintained Log Shipping, Mirroring and SRDF for disaster recovery.
• Monitored MS SQL Server performance and network issues.

Confidential

WebSphere Datapower Developer

Responsibilities:

• Created Application Domains, objects like Web Service proxies, Multi-Protocol Gateways as per the requirements.
• Generated keys, CSRs and self-signed certificates using Crypto tool.
• Created Crypto profiles, SSL proxy profiles as part of SSL implementation.
• Configured WSP, MPGW Services in DataPower. Implemented WS Security, SSL
• Created Load Balancer Groups to load balance the requests to multiple back end points.
• Created AAA policies to authenticate and authorize user requests using LDAP.
• Developed and configured WSDL and XML proxies.
• Experience in working with multiple development and infrastructure teams.
• Performed general operation tasks such as Firmware upgrade, User management, capacity planning
• Developed Message flows to transform messages from XML to COBOL copybook format.
• Worked on XSLT and used XML Transformation node to transform an XML message to another form
• Active participant in monitoring the middleware and Perform daily on call tasks (checking error logs, Fail over queues, System Logs, Backed out messages) to maintain a healthy system.